3 INSERT INTO metabib.metarecord (fingerprint,master_record)
5 FROM (SELECT DISTINCT ON (fingerprint)
6 fingerprint, id, quality
7 FROM biblio.record_entry
8 ORDER BY fingerprint, quality desc) AS x
9 WHERE fingerprint IS NOT NULL
10 AND fingerprint NOT IN ( SELECT fingerprint FROM metabib.metarecord);
12 INSERT INTO metabib.metarecord_source_map (metarecord,source)
14 FROM biblio.record_entry b
15 JOIN metabib.metarecord m ON (m.fingerprint = b.fingerprint)
16 LEFT JOIN metabib.metarecord_source_map s ON (b.id = s.source)
21 VACUUM FULL ANALYZE VERBOSE metabib.metarecord;
22 VACUUM FULL ANALYZE VERBOSE metabib.metarecord_source_map;