Home > mailing lists

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

From	Simon Riggs
Subject	Re: simple join uses indexes, very slow
Date	March 28, 2006 17:18:04
Msg-id	1143569869.32384.37.camel@localhost.localdomain Whole thread Raw
In response to	Re: simple join uses indexes, very slow (george young <gry@ll.mit.edu>)
Responses	Re: simple join uses indexes, very slow
List	pgsql-performance

Tree view

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

pgsql-performance by date:

From: "Joshua D. Drake"
Date: 28 March 2006, 16:52:59
Subject: Re: Slow performance on Windows .NET and OleDb

From: Marcos
Date: 28 March 2006, 17:34:02
Subject: Decide between Postgresql and Mysql (help of comunity)

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

Previous

Next