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
