Re: simple join uses indexes, very slow

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: gry@xxxxxxxxxx
Subject: Re: simple join uses indexes, very slow
From: Simon Riggs <simon@xxxxxxxxxxxxxxx>
Date: Tue, 28 Mar 2006 19:17:49 +0100
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <20060328102200.39077862.gry@xxxxxxxxxx>
References: <20060327134733.72422d23.gry@xxxxxxxxxx> <1143534654.3839.251.camel@xxxxxxxxxxxxxxxxxxxxx> <20060328102200.39077862.gry@xxxxxxxxxx>

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

Follow-Ups:
- Re: simple join uses indexes, very slow
  - From: george young

References:
- simple join uses indexes, very slow
  - From: george young
- Re: simple join uses indexes, very slow
  - From: Simon Riggs
- Re: simple join uses indexes, very slow
  - From: george young

Prev by Date: Re: Slow performance on Windows .NET and OleDb
Next by Date: Decide between Postgresql and Mysql (help of comunity)
Previous by thread: Re: simple join uses indexes, very slow
Next by thread: Re: simple join uses indexes, very slow
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux