From: | Dennis Roesler <Dennis_Roesler(at)am(dot)exch(dot)hp(dot)com> |
---|---|
To: | |
Subject: | list limit for IN predicate? |
Date: | 1999-02-18 14:25:24 |
Message-ID: | 36CC22D4.C4C8A121@am.exch.hp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Does anyone know what the maximum number of items there can be in a list
for the IN predicate. I have a maintenance script that extracts
information from one dB, builds a list for the IN predicate, connects to
a different dB, and runs a query based on the list generated. In one
instance the list that was built had ~450 items in the list, which
crashed the server.
Is it a matter of the size of the list in characters and not items in
the list? The whole list, including the quotes around the items in the
list, commas, etc. was ~5k characters.
Thanks
Dennis
---------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1999-02-18 16:40:21 | Re: [HACKERS] Continued problems with pgdump, Large Objects and crashing backends |
Previous Message | Ron Snyder | 1999-02-18 14:13:53 | large objects failing (hpux10.20 sparc/solaris 2.6, gcc 2.8.1) |