Re: EXPLAIN ANALYZE on 8.2 - Mailing list pgsql-performance

From Tom Lane
Subject Re: EXPLAIN ANALYZE on 8.2
Date
Msg-id 21146.1166112702@sss.pgh.pa.us
Whole thread Raw
In response to EXPLAIN ANALYZE on 8.2  (Evgeny Gridasov <eugrid@fpm.kubsu.ru>)
Responses Re: EXPLAIN ANALYZE on 8.2  (Evgeny Gridasov <eugrid@fpm.kubsu.ru>)
List pgsql-performance
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 by date:

Previous
From: Ron
Date:
Subject: Re: New to PostgreSQL, performance considerations
Next
From: Matthew O'Connor
Date:
Subject: Re: New to PostgreSQL, performance considerations