-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Although with your very little load a manual or cron based vacuum full once a week will be more than enough. I'm doing a biweekly vacuum full with one of my customer's machines (an office application that uses pg as backend) and never had complaints or problems. That setup makes about 5000 transactions a day - still a very low load for postgres. On Wednesday 19 January 2005 03:42 pm, Dann Corbit wrote: > 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 - -- UC - -- Open Source Solutions 4U, LLC 2570 Fleetwood Drive Phone: +1 650 872 2425 San Bruno, CA 94066 Cell: +1 650 302 2405 United States Fax: +1 650 872 2417 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (GNU/Linux) iD8DBQFB7v/NjqGXBvRToM4RAsB5AKCTeELPQA9R/kce4rD78X0mJE+JdQCeIIak rs7QSe2KHopOt9AkADg+ofU= =KRuh -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
