On Mon, Mar 30, 2009 at 12:42 PM, wrote:
Arguably in this case the actual query should run faster than the
EXPLAIN
ANALYZE version, since the cache is hot. (Though that'd only likely
shave
a few dozen ms off the runtime)
Joining a lot of tables together? Could be GEQO kicking in.
Only if I get different query plans for the query depending on whether
it's being EXPLAIN ANALYZEd or not. That seems unlikely...

-Dan

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 6 of 19 | next ›
Discussion Overview
grouppgsql-performance @
categoriespostgresql
postedMar 30, '09 at 5:57p
activeMar 30, '09 at 9:55p
posts19
users5
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2019 Grokbase