]> git.donarmstrong.com Git - wannabuild.git/commit
Use public.locks as locking area.
authorPhilipp Kern <pkern@debian.org>
Mon, 31 Oct 2011 14:46:10 +0000 (14:46 +0000)
committerPhilipp Kern <pkern@debian.org>
Mon, 31 Oct 2011 14:46:10 +0000 (14:46 +0000)
commit44802d376dd36e53c019dc95a38618e693fd795e
tree517251e302335f878c411c4db1112bda1e92ffcd
parent1d0136f3738977c8c827aa79e302d42092ec95b3
Use public.locks as locking area.

Since the central packages table was introduced we used FOR UPDATE
for synchronization between different wanna-build calls.  This
causes a write for every locked row, which is unhelpful for WAL
traffic considering that merge-v3 needs to lock everything.

Let's synchronize by using FOR UPDATE on public.locks instead,
which should ease the WAL load a lot.
bin/wanna-build
schema/old-migrations/lock_table.sql [new file with mode: 0644]