Postgres Pro
Downloads
Home   >   mailing lists

Re: WHERE ... NOT NULL ... OR ... (SELECT...) - Mailing list pgsql-sql

From Mario Splivalo
Subject Re: WHERE ... NOT NULL ... OR ... (SELECT...)
Date
Msg-id 55DB0A4E.4030600@splivalo.hr
Whole thread Raw
In response to Re: WHERE ... NOT NULL ... OR ... (SELECT...)  ("Dickson S. Guedes" <listas@guedesoft.net>)
List pgsql-sql
Tree view 
On 08/24/2015 01:34 PM, Dickson S. Guedes wrote:
> 2015-08-23 18:01 GMT-03:00 Mario Splivalo <mario@splivalo.hr>:
>>  Unique  (cost=193891.55..212017.84 rows=329569 width=162)
>>   ->  Sort  (cost=193891.55..194715.47 rows=329569 width=162)
> 
> I'm not answering your original question, but since the queries in your UNION
> will be mutually exclusive, you could replace your UNION by UNION ALL to rip off
> the Sort+Unique Node.
> 

Good point, thank you! :)
Mario
-- 
Mario Splivalo
mario@splivalo.hr

"I can do it quick, I can do it cheap, I can do it well. Pick any two."

pgsql-sql by date:

Previous
From: "Dickson S. Guedes"
Date:
Subject: Re: WHERE ... NOT NULL ... OR ... (SELECT...)
Next
From: Amreen Khan
Date:
Subject: Reassign permissions