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