Re: EXPLAIN ANALYZE on 8.2

Поиск
Список
Период
Сортировка
От Evgeny Gridasov
Тема Re: EXPLAIN ANALYZE on 8.2
Дата
Msg-id 20061214192920.c75385d6.eugrid@fpm.kubsu.ru
обсуждение исходный текст
Ответ на Re: EXPLAIN ANALYZE on 8.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: EXPLAIN ANALYZE on 8.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Tom,
Hello.

This is a Linux Debian 3.1 ontop of 2x XEON 3.4 Ghz.
PostgreSQL is 8.2 checked out from CVS REL8_2_STABLE yesterday.
I'm running the same Postgres on another machine,
with Debian Etch and have the same results.

On Thu, 14 Dec 2006 11:11:42 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Evgeny Gridasov <eugrid@fpm.kubsu.ru> writes:
> > Running the same query on pg 8.2 through EXPLAIN ANALYZE takes 4x-10x time as running it without it.
>
> If your machine has slow gettimeofday() this is not surprising.  8.2 is
> no worse (or better) than any prior version.
>
> Some quick arithmetic from your results suggests that gettimeofday() is
> taking about 3.3 microseconds, which is indeed pretty awful.  What sort
> of machine is this exactly?
>
>             regards, tom lane
>

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

Предыдущее
От: Arnaud Lesauvage
Дата:
Сообщение: Re: Slow update with simple query
Следующее
От: Mark Lewis
Дата:
Сообщение: Re: Slow update with simple query