Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-performance by date

Next:From: Matthew O'ConnorDate: 2006-12-14 16:16:14
Subject: Re: New to PostgreSQL, performance considerations
Previous:From: RonDate: 2006-12-14 16:03:08
Subject: Re: New to PostgreSQL, performance considerations

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group