Postgres Pro
Downloads
Home   >   mailing lists

Re: optimising UNION performance - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: optimising UNION performance
Date
Msg-id 200608281056.30900.peter_e@gmx.net
Whole thread Raw
In response to optimising UNION performance  (Rafal Pietrak <rafal@zorro.isa-geek.com>)
List pgsql-general
Tree view 
Am Montag, 28. August 2006 10:23 schrieb Rafal Pietrak:
> Is there a way to speed up the query to my 'grand total' logfile,
> constructed as a UNION of smaller (specialised) logfiles?

If it is sufficient for your purpose, you will find UNION ALL to be
significantly faster.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-general by date:

Previous
From: Rafal Pietrak
Date:
Subject: optimising UNION performance
Next
From: Alban Hertroys
Date:
Subject: Re: speeding up big query lookup