Le 06/09/2010 14:00, Valentine Gogichashvili a écrit : > [...] > I just executed a query that was 30MB big and that made Query Tool not > usable as pgAdmin was hanging when trying to open a Query Tool window > (probably trying to read the humongous history XML file). > > Probably a limit should be set (or settable in parameters) for the > size of the queries to be stored into the query history XML file or a > timeout should be set on processing of that file, when opening a Query > Tool. >
There's already a limit to a query size. See "Maximum size of a stored query" in the "Query Tool" tab. And I don't see any performance drops with a 30MB SQL file. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support