pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
query 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