On Wed, May 14, 2008 at 6:31 PM, Subbiah Stalin-XCGF84
[EMAIL PROTECTED] wrote:
Hi All,
We are doing some load tests with our application running postgres 8.2.4. At
times we see updates on a table taking longer (around
11-16secs) than expected sub-second response time. The table in question
-performance@postgresql.org
Subject: Re: [PERFORM] Update performance degrades over time
On Wed, May 14, 2008 at 6:31 PM, Subbiah Stalin-XCGF84
[EMAIL PROTECTED] wrote:
Hi All,
We are doing some load tests with our application running postgres
8.2.4. At times we see updates on a table taking
Subject: Re: [PERFORM] Update performance degrades over time
Yes we are updating one of indexed timestamp columns which gets unique
value on every update. We tried setting autovacuum_vacuum_scale_factor =
0.1 from default to make autovacuum bit aggressive, we see bloating on
both table and it's
Hi All,
We are doing some load tests with our application running postgres
8.2.4. At times we see updates on a table taking longer (around
11-16secs) than expected sub-second response time. The table in question
is getting updated constantly through the load tests. In checking the
table size