Re: Slow PG after upgrade to 8.2.9!! - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Slow PG after upgrade to 8.2.9!!
Date
Msg-id 20080828131604.GG23588@commandprompt.com
Whole thread Raw
In response to Re: Slow PG after upgrade to 8.2.9!!  (Devrim GÜNDÜZ <devrim@gunduz.org>)
List pgsql-general
On Thu, Aug 28, 2008 at 02:44:08PM +0300, Devrim GÜNDÜZ wrote:
> After restart, OS and PostgreSQL caches are cleaned up -- it might also
> slow down PostgreSQL a bit.

I'll bet this is the right answer -- before, you were mostly getting
things out of cache (memory), and right now everything has to come off
the disk.  Does iostat seem to confirm that?  Are you swapping, by any
chance?

A


--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

pgsql-general by date:

Previous
From: "Phoenix Kiula"
Date:
Subject: Vaccuum best practice: cronjob or autovaccuum?
Next
From: Andrew Sullivan
Date:
Subject: Re: Vaccuum best practice: cronjob or autovaccuum?