Yes please nuke the dupe rows
@riking pg corrupting indexes is a pg bug, not a discourse bug, we can certainly improve the performance of that insert, but the pg bug is something that needs fixing in pg
My guess is that is something todo with some sort of rude shutdown of the db engine, maybe on power loss