From: | Cedric BUSCHINI <cbuschini(at)carax(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Vacuum Problem |
Date: | 2007-12-05 07:53:07 |
Message-ID: | 475658E3.50409@carax.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello all,
I have a problem. The following message keeps appearing in logs :
---------------------------------------------------------------------------------------------------------------------------
WARNING: database "data_base" must be vacuumed within 2606182 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in
"data_base".
---------------------------------------------------------------------------------------------------------------------------
Last week I have run : 'vacuumdb -vz -U postgres -ddata_base'
Today it's still listed in 'ps aux'
---------------------------------------------------------------------------------------------------------------------------
postgres 2113 1.0 1.9 26256 20132 ? D Nov26 130:14
postgres: postgres data_base [local] VACUUM
root 2146 0.0 0.1 4616 1508 tty1 Ss Nov28 0:00 -bash
root 2176 0.0 0.0 4648 996 tty1 S+ Nov28 0:00
vacuumdb -vz -U postgres -ddata_base
postgres 2177 0.0 0.3 10260 3572 ? S Nov28 7:12
postgres: postgres data_base [local] VACUUM waiting
---------------------------------------------------------------------------------------------------------------------------
In pg_stat_activity I can see two lines mentionning 'vacuum verbose analyze'
What can I do ??
I really need help
Cedric
From | Date | Subject | |
---|---|---|---|
Next Message | Usama Dar | 2007-12-05 09:35:42 | Re: Vacuum Problem |
Previous Message | Bryan Manuel | 2007-12-05 04:48:00 | For Loop in PostGIS |