> >> Each time the record is updated, a new version is created, thus > >> lengthening the "correct" version search each time row is accessed,
> >> until, of course, the next vacuum comes along and corrects the index > >> to point to the latest version of the record. > >> > >> Is that a fair explanation? > > > > No, it's not. > > > > 1. The index points to all the versions, until they get vacuumed out. > it points to the last "current" version as updated by vacuum, or the first version > of the row. no, the index has one entry for each version of the row. This is why updating only non-indexed columns is relatively expensive in pg. Andreas ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
