Postgres Pro
Downloads
Home   >   mailing lists

Re: Help tuning autovacuum - seeing lots of relationbloat - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: Help tuning autovacuum - seeing lots of relationbloat
Date
Msg-id 20060621221150.GN93655@pervasive.com
Whole thread Raw
In response to Re: Help tuning autovacuum - seeing lots of relationbloat  ("jody brownell" <jody.brownell@q1labs.com>)
Responses Re: Help tuning autovacuum - seeing lots of relationbloat
List pgsql-performance
Tree view 
On Wed, Jun 21, 2006 at 04:41:45PM -0300, jody brownell wrote:
> BTW, in production with a similar load - autovacuum with default out of the box
> settings seems to work quite well....
>
> I double checked this earlier today.

So what's different between production and the machine with the problem?

The issue with autovac is that it will only vacuum one table at a time,
so if it's off vacuuming some other table for a long period of time it
won't be touching this table, which will be a problem. Now, if that's
actually what's happening...
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-performance by date:

Previous
From: Ron St-Pierre
Date:
Subject: Tuning New Server (slow function)
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Tuning New Server (slow function)