subject:"\[PERFORM\] EXPLAIN ANALYZE much slower than running query normally"

Re: [PERFORM] EXPLAIN ANALYZE much slower than running query normally

2004-10-11 Thread Tom Lane

"Chris Hutchinson" <[EMAIL PROTECTED]> writes: > 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

Re: [PERFORM] EXPLAIN ANALYZE much slower than running query normally

2004-10-11 Thread Janning Vygen

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

[PERFORM] EXPLAIN ANALYZE much slower than running query normally

2004-10-11 Thread 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?