Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance degrades until dump/restore - Mailing list pgsql-general

From Chris
Subject Re: Performance degrades until dump/restore
Date
Msg-id CAMv1wqcJAj_g0HUZ2__w-e_hc2YXFUkQBOrU+5kLid+A3pREaQ@mail.gmail.com
Whole thread Raw
In response to Re: Performance degrades until dump/restore  (Chris Travers <chris.travers@gmail.com>)
Responses Re: Performance degrades until dump/restore
List pgsql-general
Tree view
Hi Chris,
It is postgres 9.1, with default settings.  The autovacuum settings are all commented out, I have not change dthem. My understanding is that analyze is also run automatically by default.
 
So, I believe the answer to both questions is 'Yes'.

 
On Thu, Apr 19, 2012 at 12:47 AM, Chris Travers <chris.travers@gmail.com> wrote:
Is autovacuum running?

Are tables being analyzed from time to time?

 Best Wishes,
Chris Travers

pgsql-general by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: DROP and re-CREATE a table, and ERROR: could not open relation with OID xyz
Next
From: Yvon Thoraval
Date:
Subject: problem with serial