Re: Performance degrades until dump/restore

From: Chris <bajasands(at)gmail(dot)com>
To: Chris Travers <chris(dot)travers(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Performance degrades until dump/restore
Date: 2012-04-19 14:09:18
Message-ID: CAMv1wqcJAj_g0HUZ2__w-e_hc2YXFUkQBOrU+5kLid+A3pREaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)travers(at)gmail(dot)com>wrote:

> Is autovacuum running?
>
> Are tables being analyzed from time to time?
>
> Best Wishes,
> Chris Travers
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yvon Thoraval 2012-04-19 14:19:34 problem with serial
Previous Message Filip Rembiałkowski 2012-04-19 09:55:38 DROP and re-CREATE a table, and ERROR: could not open relation with OID xyz