Re: Slow PG after upgrade to 8.2.9!!

From: Andrew Sullivan <ajs(at)commandprompt(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Slow PG after upgrade to 8.2.9!!
Date: 2008-08-28 13:16:05
Message-ID: 20080828131604.GG23588@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)commandprompt(dot)com
+1 503 667 4564 x104
http://www.commandprompt.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2008-08-28 13:21:56 Re: Vaccuum best practice: cronjob or autovaccuum?
Previous Message Phoenix Kiula 2008-08-28 11:53:17 Vaccuum best practice: cronjob or autovaccuum?