Re: vacuuming not working? - Mailing list pgsql-general

From Jeffrey W. Baker
Subject Re: vacuuming not working?
Date
Msg-id 1018291502.9240.0.camel@heat
Whole thread Raw
In response to vacuuming not working?  ("David Esposito" <dvesposito@newnetco.com>)
Responses Re: vacuuming not working?
List pgsql-general
On Mon, 2002-04-08 at 10:40, David Esposito wrote:
> Me again,
>
> I have a problem with VACUUM. I searched the list and don't seem to see
> anyone else reporting this behavior so I'm wondering if i'm doing something
> wrong

> NOTICE:  Pages 655: Changed 9, Empty 0; Tup 40000: Vac 0, Keep 40000, UnUsed
                                                            ^^^^^^^^^^

The "Keep" number in VACUUM means some transaction can still see those
rows.  Check for long-lived transactions hanging around.


pgsql-general by date:

Previous
From: Ben
Date:
Subject: Re: Do I just not understand count()?
Next
From: Clinton Adams
Date:
Subject: Re: Do I just not understand count()