From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Cc: | Marek Dabrowski <marek(dot)dabrowski(at)infor(dot)pl> |
Subject: | Re: VACUMM problem |
Date: | 2005-09-03 14:01:16 |
Message-ID: | 200509031001.17118.xzilla@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Saturday 03 September 2005 09:21, Marek Dabrowski wrote:
> Hello
>
> I didn't do VACUUM long time and now I have problem:
>
> WARNING: some databases have not been vacuumed in over 2 billion
> transactions
> DETAIL: You may have already suffered transaction-wraparound data loss.
>
> What I have to do to resolve this problem?
>
I would recommend you go through each database in your cluster and run "vacuum
verbose;" any tables that have a high number of unused tuples in the
output (say more unused than used) should have vacuum full <tablename> run on
them. Also at the end of each vacuum run, it will tell you how many free
pages you need... write this down and adjust your postgresql.conf
accordingly. Finally I would suggest you set up an automated process to run
vaccum for you, or enable autovacuum if it is available. The docs can help
you with specifics on most of these items.
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-09-04 14:39:51 | Re: How to optimize Postgres Database |
Previous Message | Marek Dabrowski | 2005-09-03 13:21:47 | VACUMM problem |