Re: Tweaking PG (again)

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
Cc: "PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Tweaking PG (again)
Date: 2008-11-13 19:10:45
Message-ID: dcc563d10811131110g574d1079vaa5757d8efa6031@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 13, 2008 at 11:59 AM, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Teodor Sigaev 2008-11-13 19:11:39 Re: still gin index creation takes forever
Previous Message pgsql-general 2008-11-13 19:03:22 Table bloat in 8.3