Re: PgAdmin III 1.12 crazy memory usage

On Fri, Oct 1, 2010 at 2:21 PM, Thom Brown <thom(at)linux(dot)com> wrote:
> On 1 October 2010 14:12, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>> On Fri, Oct 1, 2010 at 2:00 PM, Thom Brown <thom(at)linux(dot)com> wrote:
>>> I can't recreate this, so it may not be much help, but I left PgAdmin
>>> running with no query windows open at all, and eventually I noticed my
>>> PC slowing right down as memory started to swap.  I've attached a
>>> screenshot to show its memory usage.
>>
>> VM size of a gig? Thats small for Windows isn't it? :-p
>>
>>> Actions I had performed earlier are attempting to select all rows from
>>> a massive table, and closed that result window a few seconds into it
>>> attempting to fetch results.
>>
>> That's where my suspicions lie. Can you try to reproduce it by doing that again?
>
> No, I've attempted that with several large tables, but it doesn't make
> any noticeable difference.  Where it's actually started fetching
> results and displaying them, closing the window causes pgAdmin to
> correctly returns the memory.  I've also checked what's happening
> server-side when closing the window, and the query is cancelled.  Is
> it theorically possible for pgAdmin to fail to cancel the query when
> closing the results window?

Well it shouldn't be, but it's always possible we missed something.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise Postgres Company