Horton

Re: Query limitations (size, number of UNIONs ...)

Stephen Frost <sfrost@snowman.net>

View thread
From: Stephen Frost <sfrost@snowman.net>
To: Marc Mamin <m.mamin@gmx.net>
Cc: pgsql-performance@postgresql.org
Date: 2005-06-03T13:27:20Z
Lists: pgsql-performance 
* Marc Mamin (m.mamin@gmx.net) wrote:
> I've just made a first test wich resulted in a query being 15KB big annd
> containing 63 UNION.

If the data is distinct from each other or you don't mind duplicate
records you might try using 'union all' instead of 'union'.  Just a
thought.

	Stephen