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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
