Re: EXPLAIN ANALYZE on 8.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Evgeny Gridasov <eugrid(at)fpm(dot)kubsu(dot)ru>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: EXPLAIN ANALYZE on 8.2
Date: 2006-12-14 16:11:42
Message-ID: 21146.1166112702@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Evgeny Gridasov <eugrid(at)fpm(dot)kubsu(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Evgeny Gridasov 2006-12-14 16:29:20 Re: EXPLAIN ANALYZE on 8.2
Previous Message Tom Lane 2006-12-14 15:58:56 Re: Operator class group proposal

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew O'Connor 2006-12-14 16:16:14 Re: New to PostgreSQL, performance considerations
Previous Message Ron 2006-12-14 16:03:08 Re: New to PostgreSQL, performance considerations