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.
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
In response to
pgsql-performance by date
|Next:||From: Marcos||Date: 2006-03-28 15:31:42|
|Subject: Decide between Postgresql and Mysql (help of comunity)|
|Previous:||From: george young||Date: 2006-03-28 15:22:00|
|Subject: Re: simple join uses indexes, very slow|