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 Simon Riggs
Subject Re: [COMMITTERS] pgsql: If we expect a hash join to be performed in multiple batches,
Date
Msg-id 1238692283.5444.123.camel@ebony.2ndQuadrant
Whole thread Raw
Responses Re: [COMMITTERS] pgsql: If we expect a hash join to be performed in multiple batches,
List pgsql-hackers
Tree view 
On Thu, 2009-03-26 at 17:15 +0000, Tom Lane wrote:
> Log Message:
> -----------
> If we expect a hash join to be performed in multiple batches, suppress
> "physical tlist" optimization on the outer relation (ie, force a projection
> step to occur in its scan).  This avoids storing useless column values when
> the outer relation's tuples are written to temporary batch files.

Can we add "batches=N" to the EXPLAIN output for Hash and/or Hash Join?

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Path case sensitivity on windows
Next
From: Jeff Davis
Date:
Subject: Re: [pgsql-www] Mentors needed urgently for SoC & PostgreSQL Student Internships