[PERFORM] Maximum number of sequences that can be created

2012-05-11 Thread Vidhya Bondre
Hi All, Is there any max limit set on sequences that can be created on the database ? Also would like to know if we create millions of sequences in a single db what is the downside of it. Regards Vidhya

Re: [PERFORM] Maximum number of sequences that can be created

2012-05-11 Thread Robert Klemme
On Fri, May 11, 2012 at 12:50 PM, Vidhya Bondre meetvbon...@gmail.com wrote: Is there any max limit set on sequences that can be created on the database ? Also would like to know if we create millions of sequences in a single db what is the downside of it. On the contrary: what would be the

Re: [PERFORM] Could synchronous streaming replication really degrade the performance of the primary?

2012-05-11 Thread MauMau
From: Fujii Masao masao.fu...@gmail.com Though I cannot show the detail for some reasons, as far as I measured the performance overhead of sync rep by using pgbench, the overhead of throughput was less than 10%. When measuring sync rep, I used two set of physical machine and storage for the