1. First things first: vacuum cannot delete tuples that are still
visible to any old running transactions. You might have some very long
queries or transactions that prevent it from cleaning properly:
select * from pg_stat_activity where xact_start now()-interval '10 minutes';
2. On 8.3 and
Royce Ausburn royce...@inomial.com writes:
Since sending this first email I've up'd the autovacuum log level and I've
noticed that the same tables seem to be auto vacuum'd over and over againâ¦
Some of the tables are a bit surprising in that they're updated
semi-regularly, but not enough
On Tue, Sep 27, 2011 at 7:49 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Royce Ausburn royce...@inomial.com writes:
Since sending this first email I've up'd the autovacuum log level and I've
noticed that the same tables seem to be auto vacuum'd over and over again…
Some of the tables are a bit
On 27/09/2011, at 8:29 PM, Marti Raudsepp wrote:
1. First things first: vacuum cannot delete tuples that are still
visible to any old running transactions. You might have some very long
queries or transactions that prevent it from cleaning properly:
select * from pg_stat_activity where
Hi all,
I have a problem with autovacuum apparently not doing the job I need it to do.
I have a table named datasession that is frequently inserted, updated and
deleted from. Typically the table will have a few thousand rows in it. Each
row typically survives a few days and is updated every
Royce Ausburn royce...@inomial.com writes:
I have a problem with autovacuum apparently not doing the job I need it to do.
Hm, I wonder whether you're getting bit by bug #5759, which was fixed
after 8.3.12.
I have a table named datasession that is frequently inserted, updated and
deleted
On 27/09/2011, at 2:21 PM, Tom Lane wrote:
Royce Ausburn royce...@inomial.com writes:
I have a problem with autovacuum apparently not doing the job I need it to
do.
Hm, I wonder whether you're getting bit by bug #5759, which was fixed
after 8.3.12.
If this were the case, would I see