From: Tom Lane <tgl@sss.pgh.pa.us>
To: Evgeny Gridasov <eugrid@fpm.kubsu.ru>
Cc: pgsql-performance@postgresql.org
Subject: Re: EXPLAIN ANALYZE on 8.2
Date: Thu, 14 Dec 2006 11:11:42 -0500
Message-ID: <21146.1166112702@sss.pgh.pa.us> (raw)
In-Reply-To: <20061214163230.d46f0138.eugrid@fpm.kubsu.ru>
References: <20061214163230.d46f0138.eugrid@fpm.kubsu.ru>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, eugrid@fpm.kubsu.ru
Subject: Re: EXPLAIN ANALYZE on 8.2
In-Reply-To: <21146.1166112702@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox