Re: simple join uses indexes, very slow

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: gry(at)ll(dot)mit(dot)edu
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: simple join uses indexes, very slow
Date: 2006-03-28 18:17:49
Message-ID: 1143569869.32384.37.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Madison Kelly 2006-03-28 18:57:37 Re: Decide between Postgresql and Mysql (help of comunity)
Previous Message Joshua D. Drake 2006-03-28 17:52:23 Re: Slow performance on Windows .NET and OleDb