On Tue, Sep 26, 2006 at 08:51:10AM -0400, Tom Lane wrote: > > 3. Do nothing. Let index scans mark the index tuple as dead when it's > > convenient. There's no correctness problem with just leaving dead index > > tuples there, because you have to check the index quals on each heap > > tuple anyway when you scan. > > And we're back to routine REINDEX I guess :-(. This doesn't seem like a > satisfactory answer.
Couldn't vacuum just eliminate tuples marked dead? Heck, don't we do that anyway right now? Granted, you'd want to periodically ensure that you scan the entire index, but that shouldn't be horribly hard to set up. -- Jim Nasby [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
