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 20050717223259.4eca3b8c@thunder.logicalchaos.org
обсуждение исходный текст
Ответ на Re: Huge performance problem between 7.4.1 and 8.0.3 -  ("Matthew T. O'Connor" <matthew@zeut.net>)
Список pgsql-performance
When grilled further on (Mon, 18 Jul 2005 00:18:43 -0400),
"Matthew T. O'Connor" <matthew@zeut.net> confessed:

> Have you turned on the query logging to see what queries are
> taking so long?
>

Yeah.  In the original message is a typical query.  One from 741 and the other
on 803.  On 803, an explain analyze is done twice.  Once during the problem,
once when the system is idle.  On 741, the query behaves the same no matter
what...

Cheers,
Rob

--
 22:31:18 up 4 days,  2:06,  8 users,  load average: 0.25, 0.18, 0.11
Linux 2.6.5-02 #8 SMP Mon Jul 12 21:34:44 MDT 2004

Вложения

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

Предыдущее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: Huge performance problem between 7.4.1 and 8.0.3 -
Следующее
От: Robert Creager
Дата:
Сообщение: Re: Huge performance problem between 7.4.1 and 8.0.3 - CS