Postgres and mod_perl: table locked during vacuum?

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgres and mod_perl: table locked during vacuum?
Date: 2002-06-17 14:02:58
Message-ID: aekq55$1p5t$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We are experiencing a fairly predictable lock-up in the overnight VACUUM
ANALYZE maintenance script. The VACUUM gets to the pg_class table and
then stops, obviously waiting for something else to give up control of
the table. The VACUUM script resumes precisely when the web server is
bounced. The web server is using mod_perl, and mod_perl uses DBI code
(in a locally developed module that does establish a connection at
*compile* time in order to verify existence of tables used in the
code). What puzzles me is that the start-up code does not do any
UPDATEs or DELETEs, so although some of the connections do not have
AutoCommit enabled, I don't understand why pg_class would seem to be
locked in a transaction.

--
Jeff Boes vox 616.226.9550 ext 24
Database Engineer fax 616.349.9076
Nexcerpt, Inc. http://www.nexcerpt.com
...Nexcerpt... Extend your Expertise

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Fankhauser 2002-06-17 14:58:23 Re: set permanent date style
Previous Message Brian McCane 2002-06-16 14:38:13 Re: Indexes on separate disk ?