Re: What to index to speed up my UNION views?

From: Ashley Moran <work(at)ashleymoran(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: What to index to speed up my UNION views?
Date: 2006-03-28 09:15:02
Message-ID: 200603281015.02196.work@ashleymoran.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday 28 March 2006 10:05, Martijn van Oosterhout wrote:
> That's because it's decribed in the SQL standard. UNION ALL just joins
> the results of the two queries. UNION removes duplicates which usually
> means sorting and comparing the tuples. UNION ALL is faster and usually
> what you want anyway...

Yes that's exactly what I want. Thanks for pointing out the difference

In response to

Browse pgsql-general by date

  From Date Subject
Next Message surabhi.ahuja 2006-03-28 09:47:41 32 bit applications against 64 bit postgres server
Previous Message Martijn van Oosterhout 2006-03-28 09:05:16 Re: What to index to speed up my UNION views?