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 по дате отправления:

Предыдущее
От: "Martin Teoh"
Дата:
Сообщение: set permanent date style
Следующее
От: Ragnar Kjørstad
Дата:
Сообщение: Re: set permanent date style