Postgres Pro
Downloads
Home   >   mailing lists

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

From Reid Thompson
Subject Re: degenerate performance on one server of 3
Date
Msg-id 4A2732E7.4020802@ateb.com
Whole thread Raw
In response to Re: degenerate performance on one server of 3  (Erik Aronesty <erik@q32.com>)
Responses Re: degenerate performance on one server of 3
List pgsql-performance
Tree view 
Erik Aronesty wrote:
> I think, perhaps, autovac wasn't running on that machine.
>
> Is there any way to check to see if it's running?
>

since it looks like stats are on too....

http://www.network-theory.co.uk/docs/postgresql/vol3/ViewingCollectedStatistics.html

read the entry on pg_stat_all_tables

pgsql-performance by date:

Previous
From: Janine Sisk
Date:
Subject: Re: Pointers needed on optimizing slow SQL statements
Next
From: Scott Marlowe
Date:
Subject: Re: Pointers needed on optimizing slow SQL statements