Re: Subject: bool / vacuum full bug followup

From: Scott Marlowe <scott(dot)marlowe(at)ihs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Subject: bool / vacuum full bug followup
Date: 2002-05-03 15:37:36
Message-ID: Pine.LNX.4.33.0205030936250.1594-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2 May 2002, Tom Lane wrote:

> Scott Marlowe <scott(dot)marlowe(at)ihs(dot)com> writes:
> > And after that, the table started growing after all vacuum fulls. I can't
> > reproduce it now.
>
> Perhaps you had an open transaction laying about? That'd prevent vacuum
> from recovering space ...

I thought of that, but no, I had just rebooted my box, and was using top
to view all the postgres user activities, and my psql session was the only
thing attached to it. If I can get it to do it, I'll pg_ctl stop/pg_ctl
start the database and see if it keeps doing it.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message david blood 2002-05-03 15:39:07 pgaccess
Previous Message Tom Jenkins 2002-05-03 14:29:46 Re: What popular, large commercial websites run