Re: Vacuum and Transactions
От | Peter Eisentraut |
---|---|
Тема | Re: Vacuum and Transactions |
Дата | |
Msg-id | Pine.LNX.4.30.0107061742280.679-100000@peter.localdomain обсуждение исходный текст |
Ответ на | Vacuum and Transactions ("Trewern, Ben" <Ben.Trewern@mowlem.com>) |
Список | pgsql-general |
Trewern, Ben writes: > If there is a transaction running when 'vacuumdb -a -z' is run (as a cron > job) it stops running at that database till the transaction completes. That > is not so much of a problem until a new client tries to connect to the > database. This new connection hangs, waiting for the vacuum to complete. There are plans to make vacuum less intrusive in the next major release, but until then this is what you have to deal with. Unless you really need to run vacuum all the time you should schedule it for low activity times. Yes, that means 24/7 100% uptime is not *really* feasible with PostgreSQL. > This email and any attachments transmitted with it are confidential If the email is confidential you shouldn't send it to public mailing lists. -- Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
В списке pgsql-general по дате отправления: