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

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Marc Mamin <m(dot)mamin(at)gmx(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query limitations (size, number of UNIONs ...)
Date: 2005-06-03 13:27:20
Message-ID: 20050603132720.GB30011@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

* Marc Mamin (m(dot)mamin(at)gmx(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Martin Fandel 2005-06-03 13:52:00 Re: Filesystem
Previous Message Alex Turner 2005-06-03 13:18:10 Re: Filesystem