Re: Slow PG after upgrade to 8.2.9!!

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Slow PG after upgrade to 8.2.9!!
Дата
Msg-id 20080828131604.GG23588@commandprompt.com
обсуждение исходный текст
Ответ на Re: Slow PG after upgrade to 8.2.9!!  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Список 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 по дате отправления:

Предыдущее
От: "Phoenix Kiula"
Дата:
Сообщение: Vaccuum best practice: cronjob or autovaccuum?
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Vaccuum best practice: cronjob or autovaccuum?