For the record, I've recently observed such behaviour on non-cheap 64bit server harware.
That was Pg 8.4.0. hardware specs available on request. EXPLAIN ANALYZE SELECT was over 2 times slower that SELECT. repeatedly. Answering an obligatory question: NO virtualization (vmware/xen/other) there. Question: Is there anything as normal, accepted level of performance degradation when using EXPLAIN ANALYZE compared to plain query? 2010/3/22 Tom Lane <[email protected]>: > Szymon Guz <[email protected]> writes: >> I've got a simple query. When I use explain analyze it lasts 7 times slower. >> Why? > > You've got a machine where gettimeofday() is really slow. This is > common on cheap PC hardware :-( > > regards, tom lane > > -- > Sent via pgsql-general mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Filip Rembiałkowski JID,mailto:[email protected] http://filip.rembialkowski.net/ -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
