From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
---|---|
To: | <Richard_D_Levine(at)raytheon(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org>, <pgsql-general-owner(at)postgresql(dot)org>, "Mark" <sendmailtomark(at)yahoo(dot)com> |
Subject: | Re: need an advice on running Database |
Date: | 2005-01-19 23:42:14 |
Message-ID: | D425483C2C5C9F49B5B7A41F89441547055820@postal.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yes, autovacuum is better.
I am a fossil from 7.1.3 days.
-----Original Message-----
From: Richard_D_Levine(at)raytheon(dot)com
[mailto:Richard_D_Levine(at)raytheon(dot)com]
Sent: Wednesday, January 19, 2005 2:10 PM
To: Dann Corbit
Cc: pgsql-general(at)postgresql(dot)org; pgsql-general-owner(at)postgresql(dot)org;
Mark
Subject: Re: [GENERAL] need an advice on running Database
Do you not recommend autovacuum?
Rick
"Dann Corbit"
<DCorbit(at)connx(dot)com> To: "Mark"
<sendmailtomark(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org>
Sent by: cc:
pgsql-general-owner(at)pos Subject: Re:
[GENERAL] need an advice on running Database
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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Mark
Sent: Wednesday, January 19, 2005 12:41 PM
To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Dann Corbit | 2005-01-19 23:55:35 | Re: Unique Index |
Previous Message | Rick Schumeyer | 2005-01-19 23:35:42 | Re: sorting library of congress numbers |