I get this error when I run a VACUUM: INFO: vacuuming "pg_toast.pg_toast_100194" vacuumdb: vacuuming of database "friend" failed: ERROR: could not open segment 1 of relation "pg_toast_100194_index" (target block 1226167840): No such file or directory I'm assuming I can just delete and recreate the index in question, although I'm not sure which index or table it's talking about. Any ideas? Akash ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org