When will my database crash?

From: "S(dot) C(dot)" <sc(at)eg-1(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: When will my database crash?
Date: 2004-09-08 02:08:08
Message-ID: 20040908020214.M78932@eg-1.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We have a postgres 7.4 database which never vacuum for 4 months. I try to
vacuum one time. But my manager can't bear the low performance of website. So
I had to kill the vacuum before it finished. Is it ok for a postgres 7.4
database never do vacuuming?

We have 10,000 trans every day. That would be 10,000 inserts and 10,000
updates each day.

Regards
Simon Chen.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Christopher Browne 2004-09-08 03:22:31 Re: When will my database crash?
Previous Message Tom Lane 2004-09-07 23:21:50 Re: Alternate db location