Tobias Meyer <t9m@xxxxxxx> writes: > so I did > select ctid as tid,oid,lomowner into temp table temp_pgmeta from > pg_largeobject_metadata; > select * from ( select count(tid) as cnt,max(tid), min(tid), oid from > temp_pgmeta group by oid) x where cnt > 1; > and that gave me 2951857 rows Yipes. Did you verify that the TIDs are all distinct? A possible theory is that pg_largeobject_metadata_oid_index has been corrupt for a long time, allowing a lot of duplicate entries to be made. However, unless pg_largeobject's pg_largeobject_loid_pn_index is *also* corrupt, you'd think that creation of such duplicates would still be stopped by that unique index. There's something mighty odd here. regards, tom lane
