Обсуждение: 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
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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Mark Sent: Wednesday, January 19, 2005 12:41 PM To: pgsql-general@postgresql.org Subject: [GENERAL] 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
Do you not recommend autovacuum? Rick "Dann Corbit" <DCorbit@connx.com> To: "Mark" <sendmailtomark@yahoo.com>, <pgsql-general@postgresql.org> Sent by: cc: pgsql-general-owner@pos Subject: Re: [GENERAL] 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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Mark Sent: Wednesday, January 19, 2005 12:41 PM To: pgsql-general@postgresql.org Subject: [GENERAL] 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@postgresql.org so that your message can get through to the mailing list cleanly
> 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? You should make sure PostgreSQL is properly tuned for your hardware and you should run vacuum, say, daily or so. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
Yes, autovacuum is better. I am a fossil from 7.1.3 days. -----Original Message----- From: Richard_D_Levine@raytheon.com [mailto:Richard_D_Levine@raytheon.com] Sent: Wednesday, January 19, 2005 2:10 PM To: Dann Corbit Cc: pgsql-general@postgresql.org; pgsql-general-owner@postgresql.org; Mark Subject: Re: [GENERAL] need an advice on running Database Do you not recommend autovacuum? Rick "Dann Corbit" <DCorbit@connx.com> To: "Mark" <sendmailtomark@yahoo.com>, <pgsql-general@postgresql.org> Sent by: cc: pgsql-general-owner@pos Subject: Re: [GENERAL] 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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Mark Sent: Wednesday, January 19, 2005 12:41 PM To: pgsql-general@postgresql.org Subject: [GENERAL] 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@postgresql.org so that your message can get through to the mailing list cleanly
-----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@raytheon.com > [mailto:Richard_D_Levine@raytheon.com] > Sent: Wednesday, January 19, 2005 2:10 PM > To: Dann Corbit > Cc: pgsql-general@postgresql.org; pgsql-general-owner@postgresql.org; > Mark > Subject: Re: [GENERAL] need an advice on running Database > > Do you not recommend autovacuum? > > Rick > > > > > "Dann Corbit" > > <DCorbit@connx.com> To: "Mark" > <sendmailtomark@yahoo.com>, <pgsql-general@postgresql.org> > Sent by: cc: > > pgsql-general-owner@pos Subject: Re: > [GENERAL] 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@postgresql.org > [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Mark > Sent: Wednesday, January 19, 2005 12:41 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] 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@postgresql.org 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-----