"Chris White" <cjwhite(at)cisco(dot)com> writes:
> While interrogating the table information for our database, I notice that
> some tables (i.e. gui_config, vm_mailbox, vm_message) have duplicate
> entries. Does anybody know why this would occur and is it a problem?
Probably it is :-(. You'll need to dig into the underlying catalogs
(everything you showed us are views, and joined ones at that) to see
what the apparent duplicates are coming from.
Way back when, it used to be possible for this symptom to arise from
multiple pg_shadow entries with the same usesysid; but that should not
happen now that there's a unique index on usesysid.
Have you had any system crashes recently?
regards, tom lane