pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedquery length limits
3+ messages / 2 participants
[nested] [flat]
* query length limits
@ 1999-07-15 19:13 tjk@tksoft.com <tk@uno.tksoft.com>
0 siblings, 0 replies; 3+ messages in thread
From: tjk@tksoft.com @ 1999-07-15 19:13 UTC (permalink / raw)
To: pgsql-sql
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?
I could test this of course, but I am curious about the real
limits imposed by the system, and any possible consequences,
plus any changes planned in the future which might affect
this issue.
Thanks,
Troy
Troy Korjuslommi Tksoft OY, Inc.
tjk@tksoft.com Software Development
Open Source Solutions
Hosting Services
^ permalink raw reply [nested|flat] 3+ messages in thread
* query length limits
@ 1999-07-16 01:17 tjk@tksoft.com <tk@uno.tksoft.com>
0 siblings, 0 replies; 3+ messages in thread
From: tjk@tksoft.com @ 1999-07-16 01:17 UTC (permalink / raw)
To: pgsql-sql
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?
I could test this of course, but I am curious about the real
limits imposed by the system, and any possible consequences,
plus any changes planned in the future which might affect
this issue.
Thanks,
Troy
Troy Korjuslommi Tksoft OY, Inc.
tjk@tksoft.com Software Development
Open Source Solutions
Hosting Services
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: query length limits
@ 1999-07-16 07:06 Ansley, Michael <Michael.Ansley@intec.co.za>
0 siblings, 0 replies; 3+ messages in thread
From: Ansley, Michael @ 1999-07-16 07:06 UTC (permalink / raw)
To: 'tjk@tksoft.com' <tjk@tksoft.com>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-07-16 07:06 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-07-15 19:13 query length limits tjk@tksoft.com <tk@uno.tksoft.com>
1999-07-16 01:17 query length limits tjk@tksoft.com <tk@uno.tksoft.com>
1999-07-16 07:06 RE: query length limits Ansley, Michael <Michael.Ansley@intec.co.za>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox