Versions Compared

Old Version 3

changes.mady.by.user Ian Ibbotson (Use this one)

Saved on

compared with

New Version 4

changes.mady.by.user Ian Ibbotson (Use this one)

Saved on

Key

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

...

Code Block
vacuum analyze;
possibly better:
vacuum (verbose, analyze, skip_locked);

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;

Switch on a specific source for ingest

Code Block
update host_lms set client_config = client_config || '{"ingest":true}' where code='CODE';