Re: degenerate performance on one server of 3 - Mailing list pgsql-performance

From Tom Lane
Subject Re: degenerate performance on one server of 3
Date
Msg-id 25083.1244063723@sss.pgh.pa.us
Whole thread Raw
In response to Re: degenerate performance on one server of 3  (Erik Aronesty <erik@q32.com>)
List pgsql-performance
Erik Aronesty <erik@q32.com> writes:
> I think, perhaps, autovac wasn't running on that machine.
> Is there any way to check to see if it's running?

> I have enabled all the options , and I know it's running on my other
> servers because I see

> LOG: autovacuum....  entries (a profusion of them)

> I suspect, perhaps, that it's just not showing up in the log since my
> 8.2 BSD box came with different settings by default.

8.2 has far crummier support for logging what autovacuum is doing than
8.3 does :-(.  The settings you show should mean that it's running, but
the only way to check specifically is to crank log_min_messages way up,
which will clutter your log with a lot of useless noise along with
autovacuum's messages.

            regards, tom lane

pgsql-performance by date:

Previous
From: Scott Carey
Date:
Subject: Re: Scalability in postgres
Next
From: Janine Sisk
Date:
Subject: Pointers needed on optimizing slow SQL statements