Re: [HACKERS] Locking end of indexes during VACUUM

2011-08-03 Thread Tom Lane
Simon Riggs writes: > What seems strange is that we make no attempt to check whether we have > already identified all tuples being removed by the VACUUM. We have the > number of dead tuples we are looking for and we track the number of > tuples we have deleted from the index, so we could easily ma

[HACKERS] Locking end of indexes during VACUUM

2011-08-03 Thread Simon Riggs
During btvacuumscan(), we lock the index for extension and then wait to acquire a cleanup lock on the last page. Then loop until we find a point where the index has not expanded again during our wait for lock on that last page. On a busy index this can take some time, especially when people regular