3 INSERT INTO metabib.metarecord (fingerprint, master_record)
4 SELECT DISTINCT ON (b.fingerprint) b.fingerprint, b.id
5 FROM biblio.record_entry b
9 FROM biblio.record_entry r
10 LEFT JOIN metabib.metarecord_source_map k ON (k.source = r.id)
11 WHERE k.id IS NULL AND r.fingerprint IS NOT NULL
13 AND NOT EXISTS ( SELECT 1 FROM metabib.metarecord WHERE fingerprint = b.fingerprint )
14 ORDER BY b.fingerprint, b.quality DESC;
16 INSERT INTO metabib.metarecord_source_map (metarecord, source)
18 FROM biblio.record_entry r
19 JOIN metabib.metarecord m USING (fingerprint)
23 FROM biblio.record_entry b
24 LEFT JOIN metabib.metarecord_source_map k ON (k.source = b.id)
30 VACUUM ANALYZE VERBOSE metabib.metarecord;
31 VACUUM ANALYZE VERBOSE metabib.metarecord_source_map;