Re: 7.1.2 query now uses hash-join instead of nested loop

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tim Knowles" <timknowles(at)ametco(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.1.2 query now uses hash-join instead of nested loop
Date: 2001-06-18 15:11:48
Message-ID: 1873.992877108@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Tim Knowles" <timknowles(at)ametco(dot)co(dot)uk> writes:
> I have two machines one running 7.1.1 and the other 7.1.2. I've used
> pg_dump to dump the schema and data from the 7.1.1 system and loaded it into
> 7.1.2 for testing. Some of my queries now run a lot slower as the planner
> prefers to use a hash-join instead of a nested loop.

AFAICS from the CVS change logs, there is no difference in planning
between 7.1.1 and 7.1.2. Perhaps you neglected to run VACUUM ANALYZE
on one case or the other? The difference in estimated result rows seems
awfully large...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-18 15:23:25 Re: Apache with PHP and PGSQL crashing ...
Previous Message Thalis A. Kalfigopoulos 2001-06-18 15:10:12 Re: primary/secondary index, difference