Re: Huge performance problem between 7.4.1 and 8.0.3 - CS

Поиск
Список
Период
Сортировка
От Robert Creager
Тема Re: Huge performance problem between 7.4.1 and 8.0.3 - CS
Дата
Msg-id 20050718000713.3366dad9@thunder.logicalchaos.org
обсуждение исходный текст
Ответ на Re: Huge performance problem between 7.4.1 and 8.0.3 - CS  (Robert Creager <Robert_Creager@LogicalChaos.org>)
Список pgsql-performance
When grilled further on (Sun, 17 Jul 2005 23:43:29 -0600),
Robert Creager <Robert_Creager@LogicalChaos.org> confessed:

> I've 6 runs going concurrently.  Just saw (vmstat 1) a set of 8 seconds where
> the CS didn't drop below 90k, but right now its at ~300 for over 30 seconds...

> It's bouncing all over the place, but staying reasonably well behaved overall.
>

Against 741 and the same load, CS is steady around 300 with spikes up to 4k, but
it's only been running for about 15 minutes.  All queries are < .2 seconds.

Cheers,
Rob

--
 00:03:33 up 4 days,  3:38,  6 users,  load average: 1.67, 0.98, 0.44
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Robert Creager
Дата:
Сообщение: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS
Следующее
От: Dawid Kuroczko
Дата:
Сообщение: Re: slow joining very large table to smaller ones