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.kumar@xxxxxxxxxxxxxxxx>: >> >> 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.kumar@xxxxxxxxxxxxxxxx >> Blog:http://vibhorkumar.wordpress.com >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company vibhor.kumar@xxxxxxxxxxxxxxxx Blog:http://vibhorkumar.wordpress.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general