Re: Vacuum problems - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Vacuum problems
Date
Msg-id dcc563d10901051040y1d3f7974idbbf7d5932f65bde@mail.gmail.com
Whole thread Raw
In response to Re: Vacuum problems  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
Another strategy to look at is to make autovacuum more aggresive by
putting entries for that one table into the pg_autovacuum table.  I
know that table exists in 8.3 but I don't remember if it exists in
older versions or how it works there.  But if you have that available
you can make that one relation more aggresively autovacuumed without
affecting the other relations vacuum scheduling.  On 8.3 you can set
individual cost delays, and all the other settings you'd need.  If 8.2
doesn't support this, look at migrating just for that functionality
alone.

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Vacuum problems
Next
From: "Jonah H. Harris"
Date:
Subject: Re: does postgres has the same limitation as MySQL?