[PERFORM] Maximum number of sequences that can be created
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
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 /advantage/ of being able to create millions of sequences? What's the use case? Cheers robert -- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/ -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
Re: [PERFORM] Could synchronous streaming replication really degrade the performance of the primary?
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 master and standby, and used 1Gbps network between them. Fujii-san, thanks a million. That's valuable information. The overhead less than 10% under perhaps high concurrency and write heavy workload exceeds my expectation. Great! Though I couldn't contact the testers today, I'll tell this to them next week. Regards MauMau -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
