Hi, George,
george young wrote:
>>Looks like a hash join might be faster. What is your work_mem set to?
>
> work_mem= 1024
This is 1 Megabyte. By all means, increase it, if possible.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org