OSDN Git Service

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)
commit6382448cf96a9b88d418cbaf86027b63f465b5d8
tree95445fc2553b8a5e27887ad1a0dae8855a88bd47
parent3f1e529e7897a307ff3431a06b739fa7069d792b
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