Re: autovacuum? - Mailing list pgsql-novice

From Jan Danielsson
Subject Re: autovacuum?
Date
Msg-id 453004B9.5070008@gmail.com
Whole thread Raw
In response to Re: autovacuum?  (Shane Ambler <pgsql@007Marketing.com>)
List 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.


Attachment

pgsql-novice by date:

Previous
From: Shane Ambler
Date:
Subject: Re: autovacuum?
Next
From: "Keith Worthington"
Date:
Subject: Range