Re: VACUUM/t_ctid bug (was Re: GiST concurrency commited) - Mailing list pgsql-hackers

From Gavin Sherry
Subject Re: VACUUM/t_ctid bug (was Re: GiST concurrency commited)
Date
Msg-id Pine.LNX.4.58.0508201749060.3361@linuxworld.com.au
Whole thread Raw
In response to VACUUM/t_ctid bug (was Re: GiST concurrency commited)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: VACUUM/t_ctid bug (was Re: GiST concurrency commited)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sat, 20 Aug 2005, Tom Lane wrote:

> I have committed changes that I believe fix this problem:
> http://archives.postgresql.org/pgsql-committers/2005-08/msg00213.php
> But it needs more testing.  Would you update to CVS tip and see if you
> still see the failure?

I've written some quick scripts. One just vacuums constantly (999 vacuums
to 1 vacuum full) while three other scripts three randomly insert
into, update and delete from 3 tables. There's a mix of small and large
transactions. The tables have a single int column. It is set up to run 3
million transactions across the 3 scripts.

I will try and jump onto one of the larger OSDL machines to test as well.

Gavin


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: VACUUM/t_ctid bug (was Re: GiST concurrency commited)
Next
From: Alvaro Herrera
Date:
Subject: Re: Why is lock not released?