On Tue, Jun 10, 2008 at 10:45 AM, Anton Melser <melser.anton@gmail.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?
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com