| From: | Robert Treat <robert(at)omniti(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Carol Walter <walterc(at)indiana(dot)edu> |
| Subject: | Re: Auto vacuum |
| Date: | 2007-04-18 01:57:53 |
| Message-ID: | 200704172157.54249.robert@omniti.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Tuesday 17 April 2007 16:30, Tom Lane wrote:
> Carol Walter <walterc(at)indiana(dot)edu> writes:
> > 8.2.3 is what is reported when I run psql with the -V option.
>
> In 8.2 you need to increase log_min_messages to see anything about
> autovacuum. It reports per-database activity at DEBUG1 and per-table
> activity at DEBUG2 level. Unfortunately DEBUG2 will fill your log
> with a lot of other chatter as well :-(. There's work going on
> right now to improve the reporting of autovac activity for 8.3.
>
Till then, take a look at pg_stat_all_tables, which contains information on
last autovacuum and autoanalyze runs for each table.
--
Robert Treat
Database Architect
http://www.omniti.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2007-04-18 02:01:48 | Re: Checking a size of a given database |
| Previous Message | Jessica Richard | 2007-04-18 00:34:18 | who can tell me the correct syntax to use dblink to talk to a table in another database |