]> granicus.if.org Git - postgresql/commit
Improve bulk-insert performance by keeping the current target buffer pinned
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 6 Nov 2008 20:51:15 +0000 (20:51 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 6 Nov 2008 20:51:15 +0000 (20:51 +0000)
commit85e2cedf985bfecaf43a18ca17433070f439fb0e
tree9348349050eaa2a8a863297c88502263c3a2e338
parentcdc197cf3100359cd436757adc0002dad07e3117
Improve bulk-insert performance by keeping the current target buffer pinned
(but not locked, as that would risk deadlocks).  Also, make it work in a small
ring of buffers to avoid having bulk inserts trash the whole buffer arena.

Robert Haas, after an idea of Simon Riggs'.
12 files changed:
src/backend/access/heap/heapam.c
src/backend/access/heap/hio.c
src/backend/access/heap/rewriteheap.c
src/backend/access/heap/tuptoaster.c
src/backend/commands/copy.c
src/backend/executor/execMain.c
src/backend/storage/buffer/README
src/backend/storage/buffer/freelist.c
src/include/access/heapam.h
src/include/access/hio.h
src/include/access/tuptoaster.h
src/include/storage/bufmgr.h