On 10/02/2012 05:24 AM, Colin Taylor wrote:
> My thoughts are: surely 0-row updates dont cause this or have impact on
> the vacuum. I'm still doing the same updates after all why have things
> degenerated so badly?
What exactly is bloating? Have you checked? Is it the table its self?
One of its indexes? Something else?
In response to
pgsql-performance by date
|Next:||From: Heikki Linnakangas||Date: 2012-10-02 08:11:40|
|Subject: Re: deadlock_timeout affect on performance|
|Previous:||From: Greg Williamson||Date: 2012-10-02 00:35:58|
|Subject: Re: Inserts in 'big' table slowing down the database|