Re: Re: Warning: database postgres must be vacuumed within 1000000 transactions

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: asti1987 <asti1987(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: Warning: database postgres must be vacuumed within 1000000 transactions
Date: 2011-01-04 18:49:35
Message-ID: 4D236BBF.5070601@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 01/04/2011 09:01 AM, asti1987 wrote:
>
> 8.1.23
> Im typing ¨vacuum¨ since yesterday in the backend and stop the vacuuming
> each 30 minutes, and I try again typing vacuum, but im by the number
> 890271/1000000 and its too slow!, i dont know what else to do to make it
> faster.

Per the error message you need to VACUUM the 'postgres' database. Either
connect to it with psql and run VACUUM or use the command line utility
vacuumdb as follows:

vacuumdb -U postgres postgres

Where -U is the superuser usually postgres.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2011-01-04 19:07:00 UUID column as pimrary key?
Previous Message Nicklas Avén 2011-01-04 18:43:33 Re: HNY-2011