Re: Tweaking PG (again) - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Tweaking PG (again)
Date
Msg-id dcc563d10811131110g574d1079vaa5757d8efa6031@mail.gmail.com
Whole thread Raw
In response to Tweaking PG (again)  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Responses Re: Tweaking PG (again)
List pgsql-general
On Thu, Nov 13, 2008 at 11:59 AM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
> Hi.
>
> I had tweaked my PG 8.2.6 with the very kind help of this list a
> couple years ago. It has been working fine, until recently. Not sure
> if it is after the update to 8.3 or because my DB has been growing,
> but the db is very slow now and the cache doesn't seem enough.

Everything you posted looks pretty normal.  I'd find the slowest
queries and post explain analyze to see what's happening.

pgsql-general by date:

Previous
From: "Phoenix Kiula"
Date:
Subject: Tweaking PG (again)
Next
From: Teodor Sigaev
Date:
Subject: Re: still gin index creation takes forever