Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
vacuum analyze;

Check for deleted cluster records (There should be NO clusters with no bib record where is_deleted is null)

Code Block
select is_deleted,
       count(cr.) 
from cluster_record cr 
where not exists ( select br. from bib_record br where br.contributes_to = cr.id ) 
group by is_deleted;

...