Horton

Re: simple join uses indexes, very slow

Markus Schaber <schabi@logix-tt.com>

View thread
From: Markus Schaber <schabi@logix-tt.com>
To: gry@ll.mit.edu
Cc: Simon Riggs <simon@2ndquadrant.com>, pgsql-performance@postgresql.org
Date: 2006-03-28T15:26:46Z
Lists: pgsql-performance 
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