You can also use the following query to check the autovacuum activity:
select last_autovacuum, last_autoanalyze from
"pg_catalog"."pg_stat_all_tables"
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 6/20/07, Ireneusz Pluta <[EMAIL PROTECTED]> wrote:
Sibte Abbas napisał(a):
> On 6/20/07
Sibte Abbas napisał(a):
On 6/20/07, Ireneusz Pluta <[EMAIL PROTECTED]> wrote:
Hello,
How can I make sure that autovacuum is running, beyond believing that
all autovacuum_ settings in
postgresql.conf are set correctly?
In the 8.1 I could see:
LOG: autovacuum: processing database "test"
in
On 6/20/07, Ireneusz Pluta <[EMAIL PROTECTED]> wrote:
Hello,
How can I make sure that autovacuum is running, beyond believing that all
autovacuum_ settings in
postgresql.conf are set correctly?
In the 8.1 I could see:
LOG: autovacuum: processing database "test"
in the log.
But I can't find i
