Skip site navigation (1) Skip section navigation (2)

Re: Vacuum Problem

From: Cedric BUSCHINI <cbuschini(at)carax(dot)com>
To: Usama Dar <munir(dot)usama(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Vacuum Problem
Date: 2007-12-05 10:04:46
Message-ID: 475677BE.5090301@carax.com (view raw or flat)
Thread:
Lists: pgsql-novice
Usama Dar a écrit :
>
>
> On Dec 5, 2007 12:53 PM, Cedric BUSCHINI <cbuschini(at)carax(dot)com 
> <mailto:cbuschini(at)carax(dot)com>> wrote:
>
>     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
>
>
> it seems to me that you need to vacuum more frequently, and the hint 
> seems to point you to a vacuum full for now, try "vacuumdb -avz", but 
> beaware it can be time & resource consuming.
So your advice is to stop the running vacuum and run 'vacuum -avz' ?
My actual question is the running processes are doing something or not ?



In response to

Responses

pgsql-novice by date

Next:From: Obe, ReginaDate: 2007-12-05 15:24:17
Subject: Re: For Loop in PostGIS
Previous:From: Usama DarDate: 2007-12-05 09:35:42
Subject: Re: Vacuum Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group