Re: That EXPLAIN ANALYZE patch still needs work

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: That EXPLAIN ANALYZE patch still needs work
Date: 2006-06-07 17:50:49
Message-ID: 873begq2h2.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Nope, that is certainly not the explanation, because the hash table is
> loaded in the (single) call of the Hash node at the start of the query.
> It is static all through the sampled-and-not executions of the Hash Join
> node, which is where our problem is.

At the risk of asking a stupid question, it's not perchance including that
hash build in the first sample it takes of the hash join node?

--
greg

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-06-07 17:52:12 Re: That EXPLAIN ANALYZE patch still needs work
Previous Message Tom Lane 2006-06-07 17:42:28 Re: That EXPLAIN ANALYZE patch still needs work