Re: [PERFORM] Multiple Uniques

2004-09-09 Thread Greg Stark
Tom Lane <[EMAIL PROTECTED]> writes: > Neil Conway <[EMAIL PROTECTED]> writes: > > > How many cycles are we really talking about, though? I have a patch > > which I'll send along in a few days which implements a similar > > optimization: if a subselect is referenced by EXISTS or IN, we can >

Re: [PERFORM] Multiple Uniques

2004-09-09 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Because the issue doesn't come up often enough to justify expending >> cycles to check for it. > How many cycles are we really talking about, though? I have a patch > which I'll send along in a few days which implements a similar > opt

Re: [PERFORM] Multiple Uniques

2004-09-09 Thread Neil Conway
Tom Lane wrote: Markus Schaber <[EMAIL PROTECTED]> writes: So, now my question is, why does the query optimizer not recognize that it can throw away those "non-unique" Sort/Unique passes? Because the issue doesn't come up often enough to justify expending cycles to check for it. How many cycles are

Re: [PERFORM] Multiple Uniques

2004-09-06 Thread Markus Schaber
Hi, Greg, On 02 Sep 2004 15:33:38 -0400 Greg Stark <[EMAIL PROTECTED]> wrote: > Markus Schaber <[EMAIL PROTECTED]> writes: > > > logigis=# explain select count(id) from (select ref_in_id as id from streets > > union select nref_in_id as id from streets) as blubb; > >

Re: [PERFORM] Multiple Uniques

2004-09-02 Thread Greg Stark
Markus Schaber <[EMAIL PROTECTED]> writes: > logigis=# explain select count(id) from (select ref_in_id as id from streets union > select nref_in_id as id from streets) as blubb; >QUERY PLAN > > ---

Re: [PERFORM] Multiple Uniques

2004-09-02 Thread Tom Lane
Markus Schaber <[EMAIL PROTECTED]> writes: > Today, we stumbled about the following query plan on PostGreSQL 7.4.1: > logigis=# explain select count(id) from (select distinct id from (select distinct > ref_in_id as id from streets union select distinct nref_in_id as id from streets) as > blubb)

[PERFORM] Multiple Uniques

2004-09-02 Thread Markus Schaber
Hello, Today, we stumbled about the following query plan on PostGreSQL 7.4.1: logigis=# explain select count(id) from (select distinct id from (select distinct ref_in_id as id from streets union select distinct nref_in_id as id from streets) as blubb) as blabb;