Postgres Pro
Downloads
Home   >   mailing lists

Re: [COMMITTERS] pgsql: If we expect a hash join to be performed in multiple batches, - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [COMMITTERS] pgsql: If we expect a hash join to be performed in multiple batches,
Date
Msg-id 20202.1238701799@sss.pgh.pa.us
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: If we expect a hash join to be performed in multiple batches,  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: [COMMITTERS] pgsql: If we expect a hash join to be performed in multiple batches,  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Tree view 
Simon Riggs <simon@2ndquadrant.com> writes:
> Can we add "batches=N" to the EXPLAIN output for Hash and/or Hash Join?

Are you talking about expected batches, or actual batches?  If the
former, would it be sufficient to distinguish "1" from "more than 1"?
If so, maybe changing the node title to "Batched Hash" would do.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: More message encoding woes
Next
From: Bruce Momjian
Date:
Subject: Re: Unsupported effective_io_concurrency platforms