[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;

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) as

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