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

From tv@fuzzy.cz
Subject Re: Warning: database postgres must be vacuumed within 1000000 transactions
Date
Msg-id 0b15386deb8485566a6fd88117166636.squirrel@sq.gransy.com
Whole thread Raw
In response to Warning: database postgres must be vacuumed within 1000000 transactions  (asti1987 <asti1987@gmail.com>)
Responses Re: Warning: database postgres must be vacuumed within 1000000 transactions
List 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!

1) What version of PostgreSQL is this?

2) Have you been running autovacuum? If not, have you been running VACUUM
regularly? If both answers are "no" then there may ne a lot of "garbage"
that has to be cleaned up by VACUUM.

3) If the VACUUM is slow (although I'm not sure what exactly you mean by
this), you can try to change several parameters.

   a) maintenance_work_mem - default is 16MB, increasing it may improve
the VACUUM performance significantly

   b) vacuum_cost_delay / vacuum_cost_limit - there are several cost
variavbles related to vacuuming, it's usually enough to modify just
these two so that the VACUUM acts more aggresively (e.g. set the
cost_delay to zero, and it won't sleep at all)

regards
Tomas


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Warning: database postgres must be vacuumed within 1000000 transactions
Next
From: Jeff Amiel
Date:
Subject: Table Vacuum (to prevent wraparound)