Thread: Length limit for query

Length limit for query

From

Emi Lu

Date:

24 August 2006, 09:59:26

Hello,

It appears in MySql 3.23 the limit is 16 MB.  In 4.0 and later, it is 1 GB

http://dev.mysql.com/doc/refman/4.1/en/packet-too-large.html


Could someone tell me where I can find PostgreSQL doc about the query
length please
Tks a lot!

> Hello,
>
> Just curious to know whether postgresql has any length constraint
> about where part, such as
>
>
> Query =
> [
> select col1, col2, ... coln
> from table 1, table2,
> where
>
> constraint1 + constraint2 +................................constraintN
> ]
>
> Is there any length arrange for the Query str such as 500M, 1G, etc?
> Or the query can be as long as it is.
>
> Thanks a lot!
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

Re: Length limit for query

From

Ron Johnson

Date:

24 August 2006, 11:18:24

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Emi Lu wrote:
> Hello,
>
> It appears in MySql 3.23 the limit is 16 MB.  In 4.0 and later, it is 1 GB
>
> http://dev.mysql.com/doc/refman/4.1/en/packet-too-large.html
>
>
> Could someone tell me where I can find PostgreSQL doc about the query
> length please
> Tks a lot!
>
>> Hello,
>>
>> Just curious to know whether postgresql has any length constraint
>> about where part, such as
>>
>>
>> Query =
>> [
>> select col1, col2, ... coln
>> from table 1, table2,
>> where
>>
>> constraint1 + constraint2 +................................constraintN
>> ]
>>
>> Is there any length arrange for the Query str such as 500M, 1G, etc?
>> Or the query can be as long as it is.

Wouldn't the "need" to create such a huge query indicate that that
is the wrong solution to the problem?

- --
Ron Johnson, Jr.
Jefferson LA  USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFE7bUfS9HxQb37XmcRAl7aAJ9PgoKb/jYRVFwi1/JZ5wY+n44W1QCeL4v7
4CD71Cuzs5q1M1XknMKVeYw=
=fPiZ
-----END PGP SIGNATURE-----