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&#
biah Stalin-XCGF84; pgsql-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
>
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 ques
