On Mon, Mar 30, 2009 at 1:42 PM, <dan@xxxxxxxxx> wrote: >> On Mon, Mar 30, 2009 at 12:42 PM, <dan@xxxxxxxxx> 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... Yes, you can. In fact you often will. Not because it's being explained or not, just because that's how GEQO works. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
