Re: [PERFORM] Degrading PostgreSQL 8.4 write performance

2011-06-19 Thread Pierre C
Load testing of postgresql 8.4 for OLTP application suitability showed that throughput of the database significantly degraded over time from thousands of write transactions per second to almost zero. A typical postgres benchmarking gotcha is : - you start with empty tables - t

Re: [PERFORM] Degrading PostgreSQL 8.4 write performance

2011-06-17 Thread Greg Smith
On 06/17/2011 08:48 AM, Kabu Taah wrote: Load testing of postgresql 8.4 for OLTP application suitability showed that throughput of the database significantly degraded over time from thousands of write transactions per second to almost zero...Postgres performance degraded in a couple of minute

Re: [PERFORM] Degrading PostgreSQL 8.4 write performance

2011-06-17 Thread Merlin Moncure
On Fri, Jun 17, 2011 at 7:48 AM, Kabu Taah wrote: > Load testing of postgresql 8.4 for OLTP application suitability showed that > throughput of the database significantly degraded over time from thousands > of write transactions per second to almost zero. Write transactions are in > given case ins

[PERFORM] Degrading PostgreSQL 8.4 write performance

2011-06-17 Thread Kabu Taah
Load testing of postgresql 8.4 for OLTP application suitability showed that throughput of the database significantly degraded over time from thousands of write transactions per second to almost zero. Write transactions are in given case insert/update/delete database transaction