Обсуждение: Query Tool history makes the Query Tool unusable after BIG query had been executed

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

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

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