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.
Te audire non possum. Musa sapientum fixa est in aure.
In response to
pgsql-novice by date
|Next:||From: Aaron Bono||Date: 2006-10-13 21:45:18|
|Subject: Re: Copying data from table to table (cloned tables)|
|Previous:||From: Shane Ambler||Date: 2006-10-13 17:34:03|
|Subject: Re: autovacuum?|