[postgis-users] Nested loop join = very bad performance

[Mark Cave-Ayland]

Mike Leahy wrote:

> Is this something that should be looked into, or should I just incorporate the 
> workaround of disabling nested loop joins into my code?

I find that generally PostgreSQL is fairly good at its estimates unless 
someone has already tried to tune the database. Have you changed any of 
the settings in postgresql.conf from their defaults?


ATB,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs