Re: [GENERAL] pg_dump and write locks

2005-07-19 Thread David Parker
ve test running, everything is in order, just slow. Thanks for your response, and apologies for the noise. - DAP -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 19, 2005 10:45 AM To: David Parker Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] pg

Re: [GENERAL] pg_dump and write locks

2005-07-19 Thread Tom Lane
"David Parker" <[EMAIL PROTECTED]> writes: > The observed behavior was that a pg_dump running with nothing else going > on takes a couple of minutes, but when we are running some system tests > that do heavy updates to a selection of application tables, it appears > that pg_dump blocks until the up

[GENERAL] pg_dump and write locks

2005-07-19 Thread David Parker
We have an issue with running pg_dump while a database is under reasonably heavy update load. This is 7.4.5 on Solaris 9/intel.   The observed behavior was that a pg_dump running with nothing else going on takes a couple of minutes, but when we are running some system tests that do heavy upd