Skip site navigation (1) Skip section navigation (2)

Re: Index locking considerations

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Index locking considerations
Date: 2004-09-30 22:14:20
Message-ID: 415C853C.2050806@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Tom Lane wrote:
> I've been thinking more about Gaetano Mendola's report of a
> FlushRelationBuffers failure during VACUUM FULL.  I still don't see how
> that could happen in 7.4, but I do see a real related risk in 8.0.

Just another information that could help your analysis.

The index's parent is a table that implement a "materialized view" so is
heavily updated by triggers.


Regards
Gaetano Mendola


In response to

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2004-09-30 22:46:54
Subject: obscure plperl bug
Previous:From: Jim C. NasbyDate: 2004-09-30 21:57:37
Subject: Re: Reviving Time Travel (was Re: 'TID index')

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group