| From: | Prabhjot Sheena <prabhjot(dot)sheena(at)rivalwatch(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, Forums postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | WARNING: database must be vacuumed within 8439472 transactions |
| Date: | 2014-07-07 19:56:22 |
| Message-ID: | CAOf_bQZdiQFrQtvyh5SCzQc63GZWYt=D=oOu4f2mgBKVAO9tEA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
Hello
We are using postgresql 8.3 database for last 5 yrs for this
production database and its running fine. This is our critical database
which runs 24*7. This weekend we started getting these messages
HINT: To avoid a database shutdown, execute a full-database VACUUM.
WARNING: database must be vacuumed within 8439472 transactions
i am currently running this command
vacuumdb --analyze db
while this command is running i m still getting these messages
WARNING: database must be vacuumed within 2645303 transactions.
The value of number of transactions is going down every minute
Can anyone tell me what is the best way to sort up this issue.
Thanks
Avi
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Christensen | 2014-07-07 20:15:18 | Re: [GENERAL] WARNING: database must be vacuumed within 8439472 transactions |
| Previous Message | Szymon Guz | 2014-07-07 11:02:36 | Re: cannot remove schema public |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Christensen | 2014-07-07 20:15:18 | Re: [GENERAL] WARNING: database must be vacuumed within 8439472 transactions |
| Previous Message | Andreas Joseph Krogh | 2014-07-07 18:36:31 | Re: text-prefix search in 9.4's JSONB |