Received: from s-nath-exch2.nath-ctmp.co.za ([209.212.102.30]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA90448 for ; Fri, 16 Jul 1999 03:09:42 -0400 (EDT) (envelope-from Michael.Ansley@intec.co.za) Received: by S-NATH-EXCH2 with Internet Mail Service (5.5.2448.0) id <35KRP9MZ>; Fri, 16 Jul 1999 09:06:44 +0200 Message-ID: <1BF7C7482189D211B03F00805F8527F70ED043@S-NATH-EXCH2> From: "Ansley, Michael" To: "'tjk@tksoft.com'" Cc: "'pgsql-sql@postgresql.org'" Subject: RE: query length limits Date: Fri, 16 Jul 1999 09:06:37 +0200 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain; charset="iso-8859-1" Troy wrote: >> Does Postgres have any limitations on >> the length of queries? >> >> E.g. is "select one,two,three,...thousand from one,two,three,...thousand where one = x and two is >> x and three is x and ... thousand = x" legal? >> Yes, there is. It is set to BLCKSZ * 2, at least in 6.5. BLCKSZ is normally 8192 bytes, so your query size will be 16k. However, I'm busy working on it at the moment, to make it unlimited (i.e.: limited by memory available). MikeA