Horton

Revert "Skip WAL for new relfilenodes, under wal_level=minimal."

Noah Misch <noah@leadboat.com>

View on postgr.es
Commit: 348f15e22e9456bf53bba1a1ca4e2279fb3e507a
Author: Noah Misch <noah@leadboat.com>
Date: 2020-03-22T16:24:15Z
Releases: 9.6.18 
Revert "Skip WAL for new relfilenodes, under wal_level=minimal."

This reverts commit cb2fd7eac285b1b0a24eeb2b8ed4456b66c5a09f.  Per
numerous buildfarm members, it was incompatible with parallel query, and
a test case assumed LP64.  Back-patch to 9.5 (all supported versions).

Discussion: https://postgr.es/m/20200321224920.GB1763544@rfd.leadboat.com

Files

PathChange+/−
doc/src/sgml/config.sgml modified +9 −32
doc/src/sgml/perform.sgml modified +36 −7
src/backend/access/gist/gistbuild.c modified +1 −1
src/backend/access/gist/gistutil.c modified +5 −26
src/backend/access/gist/gistxlog.c modified +0 −20
src/backend/access/heap/heapam.c modified +21 −9
src/backend/access/heap/rewriteheap.c modified +16 −5
src/backend/access/nbtree/nbtsort.c modified +32 −9
src/backend/access/rmgrdesc/gistdesc.c modified +0 −6
src/backend/access/transam/README modified +7 −38
src/backend/access/transam/xact.c modified +0 −15
src/backend/access/transam/xlogutils.c modified +7 −11
src/backend/bootstrap/bootparse.y modified +0 −4
src/backend/catalog/storage.c modified +0 −226
src/backend/commands/cluster.c modified +7 −22
src/backend/commands/copy.c modified +47 −5
src/backend/commands/createas.c modified +11 −4
src/backend/commands/matview.c modified +12 −4
src/backend/commands/tablecmds.c modified +30 −26
src/backend/nodes/copyfuncs.c modified +0 −2
src/backend/nodes/equalfuncs.c modified +0 −2
src/backend/nodes/outfuncs.c modified +0 −2
src/backend/parser/gram.y modified +0 −4
src/backend/parser/parse_utilcmd.c modified +0 −4
src/backend/storage/buffer/bufmgr.c modified +6 −119
src/backend/storage/lmgr/lock.c modified +0 −12
src/backend/storage/smgr/md.c modified +9 −43
src/backend/storage/smgr/smgr.c modified +0 −35
src/backend/utils/cache/relcache.c modified +51 −227
src/backend/utils/misc/guc.c modified +0 −12
src/backend/utils/misc/postgresql.conf.sample modified +0 −1
src/include/access/gist_private.h modified +0 −3
src/include/access/heapam.h modified +1 −0
src/include/access/rewriteheap.h modified +1 −1
src/include/catalog/storage.h modified +0 −6
src/include/nodes/parsenodes.h modified +0 −3
src/include/storage/bufmgr.h modified +0 −4
src/include/storage/lock.h modified +0 −3
src/include/storage/smgr.h modified +0 −1
src/include/utils/relcache.h modified +1 −7
src/include/utils/rel.h modified +14 −43
src/test/recovery/t/018_wal_optimize.pl deleted +0 −372
src/test/regress/expected/alter_table.out modified +0 −6
src/test/regress/expected/create_table.out modified +0 −13
src/test/regress/sql/alter_table.sql modified +0 −7
src/test/regress/sql/create_table.sql modified +0 −15

Documentation touched

Discussion