On Jun 7, 2011, at 5:18 PM, Pavel Stehule wrote: > Hello > > no, it means some different. > > we tested a SQL about 20MB with success. > > The maximum of varlena is 1GB - so it is necessary to be possible send > a query longer 1GB. But you need a free RAM 3-5x larger then query > size. >
Thanks. my bad :(. I understood this question wrong. > Regards > > Pavel Stehule > > > 2011/6/7 Vibhor Kumar <vibhor.ku...@enterprisedb.com>: >> >> On Jun 7, 2011, at 4:09 PM, AI Rumman wrote: >> >>> Is there any maximum size limit for a query string in Postgresql 9.0.1? >>> If yes, what is it ?. >> >> >> track_activity_query_size parameter. >> http://www.postgresql.org/docs/9.0/static/runtime-config-statistics.html >> >> Thanks & Regards, >> Vibhor Kumar >> EnterpriseDB Corporation >> The Enterprise PostgreSQL Company >> vibhor.ku...@enterprisedb.com >> Blog:http://vibhorkumar.wordpress.com >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company vibhor.ku...@enterprisedb.com Blog:http://vibhorkumar.wordpress.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
