Steve Lane <slane@xxxxxxxxxxxxxxxxxxxxx> writes: > Or will postgres 8 rebuild an index if it doesn't find it where it expects? No, but there's always REINDEX. > I recognize, or think I do, that PG 8 tablespaces would be required to > accomplish this. It'd certainly make it a lot easier. Also, it's probably not worth the pain to try to move system catalog indexes to RAMdisk --- that'll greatly complicate the restart process. User-table indexes could be fixed just with REINDEX. regards, tom lane
