pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Janning Vygen <vygen@gmx.de>
To: Chris Hutchinson <chris@hutchinsonsoftware.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: EXPLAIN ANALYZE much slower than running query normally
Date: Mon, 11 Oct 2004 14:15:56 +0200
Message-ID: <200410111415.56547.vygen@gmx.de> (raw)
In-Reply-To: <IDEOKBCDGGIDOBADNGAPGEFEGBAA.chris@hutchinsonsoftware.com>
References: <IDEOKBCDGGIDOBADNGAPGEFEGBAA.chris@hutchinsonsoftware.com>

Am Dienstag, 5. Oktober 2004 08:49 schrieb Chris Hutchinson:
> Running a trivial query in v7.4.2 (installed with fedora core2) using
> EXPLAIN ANALYZE is taking considerably longer than just running the query
> (2mins vs 6 secs). I was using this query to quickly compare a couple of
> systems after installing a faster disk.
>
> Is this sort of slowdown to be expected?

no.

did you run VACCUM ANALYZE before? you should do it after pg_restore your db 
to a new filesystem

in which order did you ran the queries. If you start your server and run two 
equal queries, the second one will be much faster because of some or even all 
data needed to answer the query is still in the shared buffers. 

janning





view thread (3+ messages)  latest in thread

Message-ID: <200410111415.56547.vygen@gmx.de>
Permalink:  ../200410111415.56547.vygen@gmx.de/
Also on:    postgresql.org/message-id/200410111415.56547.vygen@gmx.de

 · 

reply

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: vygen@gmx.de, chris@hutchinsonsoftware.com
  Subject: Re: EXPLAIN ANALYZE much slower than running query normally
  In-Reply-To: <200410111415.56547.vygen@gmx.de>

* 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