Horton

Re: simple join uses indexes, very slow

Simon Riggs <simon@2ndquadrant.com>

View thread
From: Simon Riggs <simon@2ndquadrant.com>
To: gry@ll.mit.edu
Cc: pgsql-performance@postgresql.org
Date: 2006-03-28T18:17:49Z
Lists: pgsql-performance 
On Tue, 2006-03-28 at 10:22 -0500, george young wrote:

> work_mem= 1024

Set that higher.

Try a couple of other plans using enable_* and let us have the EXPLAIN
ANALYZE plans.

Best Regards, Simon Riggs