Length limit for query

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Length limit for query
Date: 2006-08-24 12:59:10
Message-ID: 44EDA29E.7030108@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-08-24 13:06:02 Re: Can't open Postgres at all!!!
Previous Message Michael Fuhr 2006-08-24 12:19:07 Re: [GENERAL] Shared Objects (Dynamic loading)