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 good job.
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 ...
cug -- PharmaLine, Essen, GERMANY Software and Database Development
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
