VACUUM

# 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.
Comments