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
|
Список | 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 по дате отправления: