LP#1271661: Use unlogged tables to avoid lock churn
authorMike Rylander <mrylander@gmail.com>
Tue, 8 Apr 2014 19:36:52 +0000 (15:36 -0400)
committerMike Rylander <mrylander@gmail.com>
Tue, 8 Apr 2014 20:44:12 +0000 (16:44 -0400)
commita350a27bbffc9d42d5a711837df8bd91b4f00871
tree11dbf041612d8b67cd29275bfb4ac10be42e4694
parenta5daaf1840021e67521ba2fba590b27ad88b405d
LP#1271661: Use unlogged tables to avoid lock churn

Attempting to load a large number of bib records into a Vandelay
import queue can stall and fail, with no records getting staged
into the import queue.  It is suspected that this is because of the
locks required to maintain temp tables, which we create and destroy
for each record we look at.  Instead, let's just use unlogged tables
and empty them explicitly after each record.  Autovacuum should
protect us from bloat growth.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/012.schema.vandelay.sql