Re: Hash vs. HashJoin nodes - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Hash vs. HashJoin nodes
Date
Msg-id 424B81E3.208@familyhealth.com.au
Whole thread Raw
In response to Re: Hash vs. HashJoin nodes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> One small objection is that we'd lose the ability to separately display
> the time spent building the hash table in EXPLAIN ANALYZE output.  It's
> probably not super important, but might be a reason to keep two plan
> nodes in the tree.

Would a separate hash node help for these kinds of queries in the future:

SELECT * FROM table WHERE id IN (1,2,3,4,...massive list of scalars, ...);

Chris


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Hash vs. HashJoin nodes
Next
From: Neil Conway
Date:
Subject: Re: Hash vs. HashJoin nodes