[ADMIN] How can I tell if I'm autovacuuming?

2010-05-22 Thread Doug Gorley
>From what I see in the docs, these three settings in postgresql.conf should be enough for PostgreSQL (8.2) to autovacuum with the default settings: autovacuum = on stats_start_collector = on stats_row_level = on So, two questions: (a) Is this correct? Should autovacuum be functional now? (b) H

Re: [ADMIN] How can I tell if I'm autovacuuming?

2010-05-22 Thread Joshua D. Drake
On Sat, 2010-05-22 at 09:51 -0400, Doug Gorley wrote: > From what I see in the docs, these three settings in postgresql.conf > should be enough for PostgreSQL (8.2) to autovacuum with the default > settings: > > autovacuum = on > stats_start_collector = on > stats_row_level = on > > So, two quest

Re: [ADMIN] Jobs not running

2010-05-22 Thread Tom Lane
Alex Kogan writes: > I also noticed that when I go to Dependencies and Dependents tabs in > pgAdmin3 - I get the "OID out of range" error. Not sure if this is > related to the jobs not running. Below is the error with the statement > from logs. Well, I dunno where that command is coming from, but