| From: | "Ansley, Michael" <Michael(dot)Ansley(at)intec(dot)co(dot)za> |
|---|---|
| To: | "'tjk(at)tksoft(dot)com'" <tjk(at)tksoft(dot)com> |
| Cc: | "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | RE: query length limits |
| Date: | 1999-07-16 07:06:37 |
| Message-ID: | 1BF7C7482189D211B03F00805F8527F70ED043@S-NATH-EXCH2 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Richards | 1999-07-16 08:37:20 | Re: [HACKERS] Counting bool flags in a complex query |
| Previous Message | tjk@tksoft.com | 1999-07-16 01:17:13 | query length limits |