Skip site navigation (1) Skip section navigation (2)

Re: autovacuum?

From: Jan Danielsson <jan(dot)danielsson(at)gmail(dot)com>
To: Shane Ambler <pgsql(at)007Marketing(dot)com>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: autovacuum?
Date: 2006-10-13 21:27:21
Message-ID: 453004B9.5070008@gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Shane Ambler wrote:
[---]
>>    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.

   Thanks for the tips. I'll try to crank up the level of logging a
notch and see, and I'll also take a look at pgAdmin.

-- 
Kind Regards,
Jan Danielsson
Te audire non possum. Musa sapientum fixa est in aure.

In response to

pgsql-novice by date

Next:From: Aaron BonoDate: 2006-10-13 21:45:18
Subject: Re: Copying data from table to table (cloned tables)
Previous:From: Shane AmblerDate: 2006-10-13 17:34:03
Subject: Re: autovacuum?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group