agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Mario Splivalo <mario@splivalo.hr>
To: Dickson S. Guedes <listas@guedesoft.net>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: WHERE ... NOT NULL ... OR ... (SELECT...)
Date: Mon, 24 Aug 2015 14:13:02 +0200
Message-ID: <55DB0A4E.4030600@splivalo.hr> (raw)
In-Reply-To: <CAHHcreqvPiTG_GkfHeLBUbjxcRiL0mxEnCrZ=J_n3+kbDVfzeA@mail.gmail.com>
References: <55DA348D.9050704@splivalo.hr>
	<CAHHcreqvPiTG_GkfHeLBUbjxcRiL0mxEnCrZ=J_n3+kbDVfzeA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>

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."


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

view thread (3+ messages)

Message-ID: <55DB0A4E.4030600@splivalo.hr>
Permalink:  ../55DB0A4E.4030600@splivalo.hr/
Also on:    postgresql.org/message-id/55DB0A4E.4030600@splivalo.hr

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: mario@splivalo.hr, listas@guedesoft.net
  Subject: Re: WHERE ... NOT NULL ... OR ... (SELECT...)
  In-Reply-To: <55DB0A4E.4030600@splivalo.hr>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox