For bulk write operations (eg COPY IN), use a ring buffer of 16MB instead
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 22 Jun 2009 20:04:28 +0000 (20:04 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 22 Jun 2009 20:04:28 +0000 (20:04 +0000)
commit83fba6bba1e1ea07ebeb3132e49985b43e2851cb
treee918de47dce5485e1624049ca420189994186915
parentb20155d50f979392c60519d4a88a0984adb28b4e
For bulk write operations (eg COPY IN), use a ring buffer of 16MB instead
of the 256KB limit originally enforced by a patch committed 2008-11-06.
Per recent test results, the smaller size resulted in an undesirable decrease
in bulk data loading speed, due to COPY processing frequently getting blocked
for WAL flushing.  This area might need more tweaking later, but this setting
seems to be good enough for 8.4.
src/backend/storage/buffer/README
src/backend/storage/buffer/freelist.c