| From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
|---|---|
| To: | jody brownell <jody(dot)brownell(at)q1labs(dot)com> |
| Cc: | Csaba Nagy <nagy(at)ecircle-ag(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Help tuning autovacuum - seeing lots of relationbloat |
| Date: | 2006-06-21 22:11:50 |
| Message-ID: | 20060621221150.GN93655@pervasive.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-06-21 22:21:42 | Re: Tuning New Server (slow function) |
| Previous Message | Ron St-Pierre | 2006-06-21 21:27:41 | Tuning New Server (slow function) |