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

Re: slow plan on join when adding where clause

From: syan <kittylitter(at)people(dot)net(dot)au>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: slow plan on join when adding where clause
Date: 2010-04-13 01:19:34
Message-ID: 1271121574.3010.0.camel@syan-desktop (view raw or flat)
Thread:
Lists: pgsql-novice
Is the index clustered?
On Thu, 2010-04-01 at 14:19 -0400, Mladen Gogala wrote:
> Jasen, he does have the index, that precisely is a problem. According to 
> his statement, full table scan is faster than an index search.
> 
> Jasen Betts wrote:
> > On 2010-03-29, L. Loewe <lloewe(at)hotmail(dot)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);
> >
> >
> >   
> 
> -- 
>  
> Mladen Gogala 
> Sr. Oracle DBA
> 1500 Broadway
> New York, NY 10036
> (212) 329-5251
> http://www.vmsinfo.com 
> The Leader in Integrated Media Intelligence Solutions
> 
> 
> 
> 



In response to

Responses

pgsql-novice by date

Next:From: Donn WashburnDate: 2010-04-13 02:04:58
Subject: Getting started
Previous:From: A. KretschmerDate: 2010-04-12 12:30:07
Subject: Re: Postgres 8.4 view keys

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