Postgres Pro
Downloads
Home   >   mailing lists

Re: simple join uses indexes, very slow - Mailing list pgsql-performance

From Markus Schaber
Subject Re: simple join uses indexes, very slow
Date
Msg-id 442955B6.70102@logix-tt.com
Whole thread Raw
In response to Re: simple join uses indexes, very slow  (george young <gry@ll.mit.edu>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: george young
Date:
Subject: Re: simple join uses indexes, very slow
Next
From: ashah
Date:
Subject: Re: Massive Inserts Strategies