Re: need an advice on running Database

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "Mark" <sendmailtomark(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: need an advice on running Database
Date: 2005-01-19 21:30:32
Message-ID: D425483C2C5C9F49B5B7A41F8944154705581B@postal.corporate.connx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Vanole, Mike 2005-01-19 21:34:25 Calculating a moving average
Previous Message Chris 2005-01-19 21:13:41 Re: pg 8.0 on freebsd 5.3 install problem