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: 200402082134.18156.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Karl,

> 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-2014 The PostgreSQL Global Development Group