From 4ee9e83e915e42de57061b29b1b7adfeec89f531 Mon Sep 17 00:00:00 2001 From: Sokolov Yura Date: Tue, 18 Jul 2017 12:33:33 +0300 Subject: [PATCH] Set vacuum ring buffer 16MB Vacuum suffers a lot from small ring buffer in a way bulk writer suffered before Tom Lane's fix at 6382448cf96: > the smaller size resulted in an undesirable decrease in bulk data > loading speed, due to COPY processing frequently getting blocked > for WAL flushing. --- src/backend/storage/buffer/freelist.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/backend/storage/buffer/freelist.c b/src/backend/storage/buffer/freelist.c index 9d8ae6ae8e..4f12ff9f77 100644 --- a/src/backend/storage/buffer/freelist.c +++ b/src/backend/storage/buffer/freelist.c @@ -546,7 +546,7 @@ GetAccessStrategy(BufferAccessStrategyType btype) ring_size = 16 * 1024 * 1024 / BLCKSZ; break; case BAS_VACUUM: - ring_size = 256 * 1024 / BLCKSZ; + ring_size = 16 * 1024 * 1024 / BLCKSZ; break; default: -- 2.11.0