| From: | Shane Ambler <pgsql(at)007Marketing(dot)com> |
|---|---|
| To: | Jan Danielsson <jan(dot)danielsson(at)gmail(dot)com>, PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: autovacuum? |
| Date: | 2006-10-13 17:34:03 |
| Message-ID: | 452FCE0B.3080903@007Marketing.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Jan Danielsson wrote:
> Jan Danielsson wrote:
> [---]
>> Quick questions: Do I simply need to enable autovacuum in the
>> postgresql.conf file, or is there more to it? Will it vacuum all
>> databases, or do I need to specify which ones? If so, how?
>
> Ok, I finally found the relevant documentation. Seems I had to enable
> two other keywords in the postgresql.conf file. However, I still haven't
> figured out how I can actually verify that it *is* running the vacuum
> procedure. Any hints?
>
>
I'm not sure if there is a way.
I would think detailed enough logs should show it up but that may have
to be at debug level I am guessing.
The only one I would think of is to check the stats - I would use
pgAdmin and check the row counts on a table (these show up after a
vacuum) before and after you know a number of rows have been inserted
and see if that updates after a couple of minutes.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Danielsson | 2006-10-13 21:27:21 | Re: autovacuum? |
| Previous Message | Shane Ambler | 2006-10-13 15:31:24 | Re: autovacuum? |