Postgres Pro
Downloads
Home   >   mailing lists

Re: Query limitations (size, number of UNIONs ...) - Mailing list pgsql-performance

From Stephen Frost
Subject Re: Query limitations (size, number of UNIONs ...)
Date
Msg-id 20050603132720.GB30011@ns.snowman.net
Whole thread Raw
In response to Query limitations (size, number of UNIONs ...)  ("Marc Mamin" <m.mamin@gmx.net>)
List pgsql-performance
Tree view 
* 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
Attachment

pgsql-performance by date:

Previous
From: Alex Turner
Date:
Subject: Re: Filesystem
Next
From: "Martin Fandel"
Date:
Subject: Re: Filesystem