Re: Warning: database postgres must be vacuumed within 1000000 transactions - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Warning: database postgres must be vacuumed within 1000000 transactions
Date
Msg-id 201101040715.45123.adrian.klaver@gmail.com
Whole thread Raw
In response to Warning: database postgres must be vacuumed within 1000000 transactions  (asti1987 <asti1987@gmail.com>)
List pgsql-general
On Tuesday 04 January 2011 4:06:48 am asti1987 wrote:
> 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!
>

What is slow, the vacuum? Are you doing the vacuum on the 'postgres' database?



--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: What is pg_toast_temp_* in my DB?
Next
From: tv@fuzzy.cz
Date:
Subject: Re: Warning: database postgres must be vacuumed within 1000000 transactions