Warning: database postgres must be vacuumed within 1000000 transactions

From: asti1987 <asti1987(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Warning: database postgres must be vacuumed within 1000000 transactions
Date: 2011-01-04 12:06:48
Message-ID: 1294142808882-3326896.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I got a big problem:
Warning: database 'postgres' must be vacuumed within 1000000 transactions
HINT: To avoid database shutdown, execute a full database vacuum in
'postgres'

Warning: database 'postgres' must be vacuumed within 999999 transactions
HINT: To avoid database shutdown, execute a full database vacuum in
'postgres'

Warning: database 'postgres' must be vacuumed within 999998 transactions
HINT: To avoid database shutdown, execute a full database vacuum in
'postgres'

Warning: database 'postgres' must be vacuumed within 999997 transactions
HINT: To avoid database shutdown, execute a full database vacuum in
'postgres'

backend> vacuum

Warning: database 'postgres' must be vacuumed within 999996 transactions
HINT: To avoid database shutdown, execute a full database vacuum in
'postgres'

Warning: database 'postgres' must be vacuumed within 999995 transactions
HINT: To avoid database shutdown, execute a full database vacuum in
'postgres'

its so slow!, i dont know what else to do, it will take 20 days to do it
all, and i cant wait,
help me please!

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Warning-database-postgres-must-be-vacuumed-within-1000000-transactions-tp3326896p3326896.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shoma S Achar 2011-01-04 13:00:07 Updated Latch Patch
Previous Message André Fernandes 2011-01-04 11:04:29 Re: What is pg_toast_temp_* in my DB?