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

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Valentine Gogichashvili <valgog(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Query Tool history makes the Query Tool unusable after BIG query had been executed
Date: 2010-09-06 14:53:09
Message-ID: 4C850055.1070805@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Valentine Gogichashvili 2010-09-07 08:03:45 Re: Query Tool history makes the Query Tool unusable after BIG query had been executed
Previous Message Valentine Gogichashvili 2010-09-06 12:00:20 Query Tool history makes the Query Tool unusable after BIG query had been executed