Re: multithreading

2008/6/10 Anton Melser <melser(dot)anton(at)gmail(dot)com>:
> 2008/6/10 Dave Page <dpage(at)pgadmin(dot)org>:
>> On Tue, Jun 10, 2008 at 10:45 AM, Anton Melser <melser(dot)anton(at)gmail(dot)com> wrote:
>>> Hi,
>>> Just a quick question... are there any plans to multithread the
>>> restore from dump functionality? pgadmin spends several minutes
>>> (around 15) "not responding" while I restore my 700MB dump... and it's
>>> working away fine. It's not a biggie, but it would be nice to have the
>>> interface telling me "I'm on it"... It would probably be quite
>>> complicated to do but logically there seems no reason why I couldn't
>>> use pgadmin for work on another db while it's restoring...
>>>
>>
>> The restore runs in an entirely separate process from pgAdmin, and
>> doesn't stop you continuing to work whilst it runs (at least in my
>> limited testing here). Maybe you're seeing some platform-specific
>> quirk - what version are you running on what platform?
>
> Um... not on either Windows XP or Windows Server 2008 Standard
> (finally a decent desktop!)... pgadmin stays "not responding" for the
> entire restore. And yes, it's 1.8.4.

WinXP 32 bit, Win2008 x64.

--
echo '16i[q]sa[ln0=aln100%Pln100/snlbx]sbA0D4D465452snlbxq' | dc
This will help you for 99.9% of your problems ...