Re: auto vacuum lock on 8.1beta1 - Mailing list pgsql-hackers

From Robert Creager
Subject Re: auto vacuum lock on 8.1beta1
Date
Msg-id 20051013134036.00000427@C118181.stortek.com
Whole thread Raw
In response to Re: auto vacuum lock on 8.1beta1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, 13 Oct 2005 15:09:58 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Robert Creager <Robert.Creager@Sun.com> writes:
> > Might this be the same problem as the recent thread "database vacuum from
> > cron hanging" where Tom is: "I'm busy volatile-izing all the code in
> > bufmgr.c ... should be able to commit a fix soon."?
> 
> Seems reasonably likely, seeing that the original report involved gcc
> 3.3.something IIRC, and you're using 3.3.1.  Is this an SMP box?  The
> bug could theoretically manifest on a uniprocessor but it seems more
> likely to happen on a multiprocessor.

Yes, it's a dual Xenon box.

> 
> Too bad you didn't have it built with --enable-debug; I can't think of
> any very easy way to verify a negative refcount for that buffer without
> gdb support.

I just downloaded last nights snapshot.  I'll build with debug and try it out.

Thanks,
Rob


pgsql-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: pg_config --pgxs on Win32
Next
From: Thomas Hallgren
Date:
Subject: Re: pg_config --pgxs on Win32