Tom, > That's a definite possibility. Before 7.4 we did not emit WAL records > for data written during index build. What we could have here is that > the transaction completed and synced to WAL, but none of the data-file > writes were sent to disk before power-out. On restart, WAL replay would > faithfully update the pg_class row, but the index file would still be > empty :-(
Would this be back-patchable by a good PG hacker? The client has $$$. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
