Postgres Pro
Downloads
Home   >   mailing lists

Re: What to index to speed up my UNION views? - Mailing list pgsql-general

From Ashley Moran
Subject Re: What to index to speed up my UNION views?
Date
Msg-id 200603281015.02196.work@ashleymoran.me.uk
Whole thread Raw
In response to Re: What to index to speed up my UNION views?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: What to index to speed up my UNION views?
Next
From: "surabhi.ahuja"
Date:
Subject: 32 bit applications against 64 bit postgres server