Postgres and mod_perl: table locked during vacuum?
От | Jeff Boes |
---|---|
Тема | Postgres and mod_perl: table locked during vacuum? |
Дата | |
Msg-id | aekq55$1p5t$1@news.hub.org обсуждение исходный текст |
Ответы |
Re: Postgres and mod_perl: table locked during vacuum?
|
Список | 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
В списке pgsql-admin по дате отправления: