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

Re: Why is query selecting sequential?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Karl Denninger <karl(at)denninger(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Why is query selecting sequential?
Date: 2004-02-09 05:34:18
Message-ID: (view raw or whole thread)
Lists: pgsql-performance

> BTW, the other posted "cleaner" model doesn't work for me.  If there is NO
> row in the subtable that matches, the other version returns nothing (which
> makes sense since the initial select fails to match any rows as one of the
> things its trying to match is missing.)

Ah, wasn't thinking of that case.    Problem with not really knowing what the 
database is about.

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

pgsql-performance by date

Next:From: David TeranDate: 2004-02-11 13:03:15
Subject: select count(*) from anIntColumn where int_value = 0; is very slow
Previous:From: Stephan SzaboDate: 2004-02-08 05:36:20
Subject: Re: RE : RE : Increase performance of a UNION query that

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