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

"Tim Knowles" <[EMAIL PROTECTED]> 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 has

[GENERAL] 7.1.2 query now uses hash-join instead of nested loop

Hi, 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. I have ru