Jim Nasby <decibel@xxxxxxxxxxx> writes: > > My RFE: When vacuuming a table, pg should try to vacuum the primary key > > first. If that results in 0 recovered entries, then assume the table has no > > updates/deletes and skip the rest of that table. That makes no sense. Vacuum starts by scanning the table itself, not the indexes. It only goes to the indexes after it has found tuples that need cleaning up. There's nothing to look at in the indexes that would tell it whether there are any tuples to clean up. -- greg
