Re: strange

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: strange
Дата
Msg-id 2f4958ff1003230512k626f2799sb01371675dc4ae44@mail.gmail.com
обсуждение исходный текст
Ответ на Re: strange  (Filip Rembiałkowski <plk.zuber@gmail.com>)
Список pgsql-general


2010/3/23 Filip Rembiałkowski <plk.zuber@gmail.com>
For the record, I've recently observed such behaviour on non-cheap
64bit server harware.

That was Pg 8.4.0. hardware specs available on request.

EXPLAIN ANALYZE SELECT was over 2 times slower that SELECT. repeatedly.

Answering an obligatory question: NO virtualization (vmware/xen/other) there.

Question:
Is there anything as normal, accepted level of performance degradation
when using EXPLAIN ANALYZE compared to plain query?



Apparently you can force linux kernel to consider different time source, as it sort of guess-probes which one would be the best when it boots.
I don't remember the exact option, but it is easy to find on the net.
 

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

Предыдущее
От: Filip Rembiałkowski
Дата:
Сообщение: Re: strange
Следующее
От: Scott Mead
Дата:
Сообщение: Re: Before triggers and usage in partitioned tables