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

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 (view raw, whole thread or download thread mbox)
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


pgsql-performance by date

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

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