# cat /etc/postgresql/8.3/main/postgresql.conf | grep autovacuum #autovacuum = on # Enable autovacuum subprocess? 'on' References Official dosc: http://archives.postgresql.org//pgsql-general/2009-04/msg01024.php 將vacuumdb設定成auto的方式,而vacuumdb是獨立作業(exclusive locks)的~不會影響到資料庫更新作業的問題! auto-vacuumdb default is 'true' but 因看到網路上文章說~這個最好能每天執行~~ 但是我們目前是大量新增資料中~~且有多個使用者~~ 請教一下~~ vacuumdb可在新增資料時使用?不會影響資料的運行? 能感受到他的問題點嗎o.o 連播開發者的回應 Use Auto-vaccuming and let it handle it all itself, and auto-vacuuming doesnt put any exclusive locks on any relation which means you will not have any problems while updating tables. yeah, the pgsql-general list is always a good place to start. autovacuum is very very nice. I salute the guys who wrote that and made it work. 最後裡面的人跟我說這句 yeah, the pgsql-general list is always a good place to start. autovacuum is very very nice. I salute the guys who wrote that and made it work. |
主要特點(Main Features) >