Re: Re[2]: Search (select) options // Max SQL length?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Barry Hill <barry(at)penrallt(dot)clara(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Re[2]: Search (select) options // Max SQL length?
Date: 2000-08-19 05:09:24
Message-ID: 22118.966661764@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Barry Hill <barry(at)penrallt(dot)clara(dot)co(dot)uk> writes:
> Does anyone know how long a PostGRES SQL statement can be? In the near
> future, my above-mentioned query will grow to a few hundred SELECTS
> (Phorum) and I'm wondering how it will cope (but too lazy to
> experiment) ???

As of 7.0 there's no hard upper limit. UNIONing a few hundred SELECTs
might take longer than you really want to wait however ... perhaps some
rethinking of your data model is in order.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2000-08-19 05:22:29 Inprise/Interbase problems
Previous Message Tom Lane 2000-08-19 04:59:51 Re: [General]Postgres Upgrade