Re: [PERFORM] Postgresql Replication Performance

2012-01-04 Thread Aleksej Trofimov
On 01/04/2012 12:41 PM, Saurabh wrote: Thank you all for the valuable information. Now we have decide to go with streaming replication. I did the setup on machine and it is working good. Now I have to implement the automatic failover. Please share a solution for the same. Saurabh Gupta You ca u

Re: [PERFORM] Postgresql Replication Performance

2012-01-04 Thread Saurabh
Thank you all for the valuable information. Now we have decide to go with streaming replication. I did the setup on machine and it is working good. Now I have to implement the automatic failover. Please share a solution for the same. Saurabh Gupta -- Sent via pgsql-performance mailing list (pgsq

Re: [PERFORM] Postgresql Replication Performance

2011-12-29 Thread Aleksej Trofimov
On 12/29/2011 05:00 PM, Claudio Freire wrote: Second, is that WAL activity on streaming replication or WAL shipping is documented to contain more data than on non-replicated setups. What is not clear is how much more data. This not only affects our network bandwidth estimations, but also I/O load

Re: [PERFORM] Postgresql Replication Performance

2011-12-29 Thread Merlin Moncure
On Thu, Dec 29, 2011 at 3:33 AM, sgupta wrote: > I am doing POC on Posgtresql replication. I am using latest version of > postgresql i.e. 9.1. There are multiple replication solutions avaliable in > the market (PGCluster, Pgpool-II, Slony-I). Postgresql also provide in-built > replication solution

Re: [PERFORM] Postgresql Replication Performance

2011-12-29 Thread Claudio Freire
On Thu, Dec 29, 2011 at 11:33 AM, Aleksej Trofimov wrote: > Postgres Streaming replication is WAL based replication, so using this type > of replication you will have absolutely identical database servers, what is > best choice for HA and scaling reads. Also this choice is not practically > affect

Re: [PERFORM] Postgresql Replication Performance

2011-12-29 Thread Aleksej Trofimov
On 12/29/2011 11:33 AM, sgupta wrote: I am doing POC on Posgtresql replication. I am using latest version of postgresql i.e. 9.1. There are multiple replication solutions avaliable in the market (PGCluster, Pgpool-II, Slony-I). Postgresql also provide in-built replication solutions (Streaming rep

[PERFORM] Postgresql Replication Performance

2011-12-29 Thread sgupta
I am doing POC on Posgtresql replication. I am using latest version of postgresql i.e. 9.1. There are multiple replication solutions avaliable in the market (PGCluster, Pgpool-II, Slony-I). Postgresql also provide in-built replication solutions (Streaming replication, Warm Standby and hot standby).