Thread: Query Tool history makes the Query Tool unusable after BIG query had been executed
Query Tool history makes the Query Tool unusable after BIG query had been executed
From
Valentine Gogichashvili
Date:
Hi, 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. pgAdmin version 1.12.0 RC1. With best regards, -- Valentine Gogichashvili
Re: Query Tool history makes the Query Tool unusable after BIG query had been executed
From
Guillaume Lelarge
Date:
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
Re: Query Tool history makes the Query Tool unusable after BIG query had been executed
From
Valentine Gogichashvili
Date:
On my machine I also do not see any problems on the modern machine, the problem was to be seen on the older notebook. Sorry for not noticing the limit on the query size... strange, that though the limit is there by default, a humongous query lead to the hangup of the query tool on the older notebook :( Ok, anyway, at least I will know how to solve such a problem in case it comes again :) just delete the log file... Regards, -- Valentine Gogichashvili On Sep 6, 4:53 pm, guilla...@lelarge.info (Guillaume Lelarge) wrote: > 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-supp...@postgresql.org) > To make changes to your subscription:http://www.postgresql.org/mailpref/pgadmin-support