Re: slow plan on join when adding where clause - Mailing list pgsql-novice

From Jasen Betts
Subject Re: slow plan on join when adding where clause
Date
Msg-id hp1fsb$t0r$1@reversiblemaps.ath.cx
Whole thread Raw
In response to slow plan on join when adding where clause  ("L. Loewe" <lloewe@hotmail.com>)
Responses Re: slow plan on join when adding where clause  (Mladen Gogala <mgogala@vmsinfo.com>)
List pgsql-novice
On 2010-03-29, L. Loewe <lloewe@hotmail.com> wrote:
> Hi all

> SELECT  * FROM  events, main WHERE  main.ti > events.start and
>                                      main.ti < events.stop and sensor_id=1;

create index main_ti_sid on main(sensor_id,ti);


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fwd: Need Help Enabling Remote Connections
Next
From: Mladen Gogala
Date:
Subject: Re: slow plan on join when adding where clause