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@xxxxxxxxxxxxx> wrote: > Evgeny Gridasov <eugrid@xxxxxxxxxxxx> 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 >
