On 27.03.2006, at 21:20 Uhr, Brendan Duddridge wrote:
> Does that mean that even though autovacuum is turned on, you still
> should do a regular vacuum analyze periodically?
It seems that there are situations where autovacuum does not a really
However, in our application I have made stupid design decision which
I want to change as soon as possible. I have a "visit count" column
in one of the very large tables, so updates are VERY regular. I've
just checked and saw that autovacuum does a great job with that.
Nevertheless I have set up a cron job to do a standard vacuum every
month. I've used vacuum full only once after I did a bulk update of
about 200.000 rows ...
PharmaLine, Essen, GERMANY
Software and Database Development
In response to
pgsql-performance by date
|Next:||From: Rodrigo Madera||Date: 2006-03-27 20:16:18|
|Subject: Large Binary Objects Middleware|
|Previous:||From: Alvaro Herrera||Date: 2006-03-27 19:35:28|
|Subject: Re: count(*) performance|