Akash Garg <akash.garg@xxxxxxxxx> writes: > I'll try running the od command -- I'm just a little confused on where > I run it. I tried running od -x 41661 but that doesn't yield any > results. I'm assuming I have to run this command on the actual index > file itself -- how do I do this? See contrib/oid2name, or read the docs at http://developer.postgresql.org/docs/postgres/storage.html to learn how to figure out which file is the index. (In pre-8.0 PG, ignore what those docs say about tablespaces, but the rest of the info goes back a ways.) The short answer is you need the database's OID from pg_database, and the index's relfilenode from pg_class. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
