LP#1271661: Use unlogged tables to avoid lock churn collab/miker/1304559_and_1271661_vandelay_fixes
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 19:36:52 +0000 (15:36 -0400)
commit2441c4c29fcf6acb98c72b91c036dbb0a0b65957
treebae269117130caa78e643db83365e1da2e55c019
parentc2d15efad9e3764901a53a410b35875f404c9754
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