Re: degenerate performance on one server of 3

From: Reid Thompson <reid(dot)thompson(at)ateb(dot)com>
To: Erik Aronesty <erik(at)q32(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: degenerate performance on one server of 3
Date: 2009-06-04 02:35:19
Message-ID: 4A2732E7.4020802@ateb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2009-06-04 05:31:13 Re: Pointers needed on optimizing slow SQL statements
Previous Message Janine Sisk 2009-06-04 02:32:18 Re: Pointers needed on optimizing slow SQL statements