> A full dump and restore would definitely help. I tend not to suggest
> that often because I work with very large databases that are usually
> extremely cumbersome to dump and restore.
>
> But yeah, if you can get a successful pg_dump from your database, a
> restore should obviously clean up all of your data and index
> inconsistencies if you're willing to wait.
Thanks a lot Shaun. Appreciate the help.
- Karthik