Re: vacuuming not working?

From: "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
To: David Esposito <dvesposito(at)newnetco(dot)com>
Cc: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: vacuuming not working?
Date: 2002-04-08 18:45:01
Message-ID: 1018291502.9240.0.camel@heat
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2002-04-08 18:45:28 Re: Do I just not understand count()?
Previous Message Gregory Wood 2002-04-08 18:42:01 Re: Do I just not understand count()?