Tag Archive for 'reindex'

Dec3rd2007

PostgreSQL Re-Index, Index Corruption

Ever had a situation like this: Select from database ID where name = RICHARD; Returns and ID of 55 for example. Then go and do a query like this: Select * from some_other_table where ID = 55; Returns, “Sorry does not exist, time to die…..” Well apparently indexes when corrupt – which is NOT SUPPOSED […]