Skip site navigation (1) Skip section navigation (2)

Re: simple join uses indexes, very slow

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: gry(at)ll(dot)mit(dot)edu
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: simple join uses indexes, very slow
Date: 2006-03-28 15:26:46
Message-ID: 442955B6.70102@logix-tt.com (view raw or flat)
Thread:
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

In response to

pgsql-performance by date

Next:From: MarcosDate: 2006-03-28 15:31:42
Subject: Decide between Postgresql and Mysql (help of comunity)
Previous:From: george youngDate: 2006-03-28 15:22:00
Subject: Re: simple join uses indexes, very slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group