Re: Query Tool history makes the Query Tool unusable after BIG query had been executed

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.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com