Yes, autovacuum is better. I am a fossil from 7.1.3 days. -----Original Message----- From: Richard_D_Levine@xxxxxxxxxxxx [mailto:Richard_D_Levine@xxxxxxxxxxxx] Sent: Wednesday, January 19, 2005 2:10 PM To: Dann Corbit Cc: pgsql-general@xxxxxxxxxxxxxx; pgsql-general-owner@xxxxxxxxxxxxxx; Mark Subject: Re: need an advice on running Database Do you not recommend autovacuum? Rick "Dann Corbit" <DCorbit@xxxxxxxxx> To: "Mark" <sendmailtomark@xxxxxxxxx>, <pgsql-general@xxxxxxxxxxxxxx> Sent by: cc: pgsql-general-owner@pos Subject: Re: need an advice on running Database tgresql.org 01/19/2005 04:30 PM Once per day dump database to disk. Once per day do a vacuum full. That should be plenty. Since there are 1440 minutes per day, you are only looking at 288 transactions per day. Not exactly a taxing transaction load. -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Mark Sent: Wednesday, January 19, 2005 12:41 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: need an advice on running Database Hi, I have a small data base ~ 10 tables. each table get insert/update/delete few times a day. postgresql is running for a month. The load will increase in the near future: insert/update/delete activity will be at least one in 5 minutes. What maintenance should I need to do? Thanks, Mark. __________________________________ Do you Yahoo!? All your favorites on one personal page - Try My Yahoo! http://my.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
