From: | Denis Gasparin <denis(at)edistar(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Question regarding autovacuum in 8.1 |
Date: | 2007-08-29 10:16:52 |
Message-ID: | 46D54794.1040208@edistar.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
How is it possibile to check if autovacuum is running in 8.1.x?
"Show Autovacuum" gives me on and also i see evidence in logs where
autovacuum writes "LOG: autovacuum: processing database xxxx".
However i have no idea of what tables the autovacuum daemon is
processing because there aren't autovacuum info columns on
pg_stat_all_tables (as there are for 8.2.x).
Also I'm asking this because the size of the pg_clog is >200M and I am
worried about possible transaction ID wraparound failures...
Thank you,
Denis
Tom Lane ha scritto:
> Karl Denninger <karl(at)denninger(dot)net> writes:
>
>> But... .shouldn't autovacuum prevent this? Is there some way to look in
>> a log somewhere and see if and when the autovacuum is being run - and on
>> what?
>>
>
> There's no log messages (at the default log verbosity anyway). But you
> could look into the pg_stat views for the last vacuum time for each table.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | rafikoko | 2007-08-29 11:13:17 | pg_dump.... pg_restore...how long does it take? |
Previous Message | Jens Reufsteck | 2007-08-29 10:15:49 | Performance issue with nested loop |