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

Re: EXPLAIN ANALYZE on 8.2

From: Evgeny Gridasov <eugrid(at)fpm(dot)kubsu(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: EXPLAIN ANALYZE on 8.2
Date: 2006-12-14 16:29:20
Message-ID: 20061214192920.c75385d6.eugrid@fpm.kubsu.ru (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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: Mark LewisDate: 2006-12-14 16:34:55
Subject: Re: Slow update with simple query
Previous:From: Arnaud LesauvageDate: 2006-12-14 16:26:23
Subject: Re: Slow update with simple query

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-12-14 16:41:15
Subject: Re: EXPLAIN ANALYZE on 8.2
Previous:From: Tom LaneDate: 2006-12-14 16:11:42
Subject: Re: EXPLAIN ANALYZE on 8.2

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