Thomas Munro 98f320eb2e Increase default vacuum_buffer_usage_limit to 2MB. ... The BAS_VACUUM ring size has been 256kB since commit d526575f introduced the mechanism 17 years ago. Commit 1cbbee03 recently made it configurable but retained the traditional default. The correct default size has been debated for years, but 256kB is certainly very small. VACUUM soon needs to write back data it dirtied only 32 blocks ago, which usually requires flushing the WAL. New experiments in prefetching pages for VACUUM exacerbated the problem by crashing into dirty data even sooner. Let's make the default 2MB. That's 1.6% of the default toy buffer pool size, and 0.2% of 1GB, which would be a considered a small shared_buffers setting for a real system these days. Users are still free to set the GUC to a different value. Reviewed-by: Andres Freund <andres@anarazel.de> Discussion: https://postgr.es/m/20240403221257.md4gfki3z75cdyf6%40awork3.anarazel.de Discussion: https://postgr.es/m/CA%2BhUKGLY4Q4ZY4f1rvnFtv6%2BPkjNf8MejdPkcju3Qii9DYqqcQ%40mail.gmail.com		2024-04-06 23:12:03 +13:00
..
Makefile	Perform logical replication actions as the table owner.	2023-04-04 11:25:23 -04:00
globals.c	Increase default vacuum_buffer_usage_limit to 2MB.	2024-04-06 23:12:03 +13:00
meson.build	Update copyright for 2024	2024-01-03 20:49:05 -05:00
miscinit.c	Remove unused #include's from backend .c files	2024-03-04 12:02:20 +01:00
postinit.c	Introduce "builtin" collation provider.	2024-03-13 23:33:44 -07:00
usercontext.c	Update copyright for 2024	2024-01-03 20:49:05 -05:00