Greg Smith <greg@2ndquadrant.com> writes:
> Andy Dale wrote:
>> I will however save/backup the files before removing them (just in
>> case anything goes wrong).
> If you do go through with this, I would recommend doing a complete
> database dump afterwards using pg_dump/pg_dumpall. That should make it
> immediately obvious if you broke something with the change.
Doing pg_dump would expose the mistake if you'd removed an actual
table's files. But I'm not sure it would expose it if you removed
an index ...
regards, tom lane