Re: 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