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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [COMMITTERS] pgsql: If we expect a hash join to be performed in multiple batches,
Date: 2009-04-02 19:49:59
Message-ID: 20202.1238701799@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2009-04-02 19:57:19 pgsql: Give a better error message when trying to change
Previous Message Bruce Momjian 2009-04-02 19:20:45 pgsql: Have PL/pgSQL FETCH set DIAGNOSTICS ROW_COUNT.

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2009-04-02 19:56:02 Re: Unsupported effective_io_concurrency platforms
Previous Message Peter Eisentraut 2009-04-02 19:48:38 Re: More message encoding woes