Re: Maintenance form exection thread

On Tue, Apr 6, 2010 at 21:01, Dave Page <dpage(at)pgadmin(dot)org> wrote:
> On Tue, Apr 6, 2010 at 6:11 PM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>> Hi!
>>
>> Am I reading things right that we actually execute things from the
>> maintenance dialog (like VACUUM) on a separate thread, to keep the UI
>> responsive? Yet, it keeps hanging when we do that. My guess is that
>> we're "using up" the connection we have, and as soon as somebody else
>> needs access to the connection to do things like refresh tree
>> information, we hang and wait. Or am I reading this wrong?
>>
>> If we are, should we perhaps consider firing off these jobs on a
>> separate connection?
>
> Yeah, that would seem like a sensible idea. At first thought I guessed
> it was an issue like this
> http://svn.pgadmin.org/cgi-bin/viewcvs.cgi?rev=6458&view=rev, but on
> reflection I think your much more simple explanation is the likely
> cause.

I don' t have time to look into it right onw. Do you, or should I just
add a ticket for it for "eventual fixing"?

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/