Postgres hangs during VACUUM (autocommit = false)

Поиск
Список
Период
Сортировка
От Mark Coffman
Тема Postgres hangs during VACUUM (autocommit = false)
Дата
Msg-id 9lug8b$1ne0$1@news.tht.net
обсуждение исходный текст
Ответы Re: Postgres hangs during VACUUM (autocommit = false)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I am having trouble with setting up a scheduled VACUUM.  Since VACUUM needs
an exclusive lock, I can never get it to run.  I am using persistant
connections from a web server and use a single module to make the
connection.  I cannot autocommit because I need transactions.

So a ps gives several similar processes:

postgres 24298  0.6  1.1  6548 2964 ?        S    14:00   0:15 postgres:
httpd epilogue [local] idle in transaction
postgres 24345  0.7  1.1  6496 2984 ?        S    14:01   0:15 postgres:
httpd epilogue [local] idle in transaction
postgres 24391  0.9  1.1  6488 2900 ?        S    14:02   0:19 postgres:
httpd epilogue [local] idle in transaction

I've tried doing a $dbh->commit() ; but that does no good.  I read all the
posts I could find on this, but is there any way for me to schedule a VACUUM
that won't hang?

Autocommit is not an option.

Thanks!

Mark
epilogue.net




В списке pgsql-general по дате отправления:

Предыдущее
От: "Mihai Gheorghiu"
Дата:
Сообщение: Data types
Следующее
От: Tom Lane
Дата:
Сообщение: Re: macaddr data type issue