Length limit for query
| От | Emi Lu |
|---|---|
| Тема | Length limit for query |
| Дата | |
| Msg-id | 44EDA29E.7030108@encs.concordia.ca обсуждение |
| Ответы |
Re: Length limit for query
|
| Список | 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
В списке pgsql-general по дате отправления: