Horton

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

Noah Misch <noah@leadboat.com>

View on postgr.es
Commit: 2fbdebc248ec0694b1399f9bb2e317835baca066
Author: Noah Misch <noah@leadboat.com>
Date: 2020-03-22T16:24:13Z
Releases: 11.8 
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 +8 −31
doc/src/sgml/perform.sgml modified +38 −9
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 −21
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 −220
src/backend/commands/cluster.c modified +7 −22
src/backend/commands/copy.c modified +60 −5
src/backend/commands/createas.c modified +11 −4
src/backend/commands/indexcmds.c modified +0 −2
src/backend/commands/matview.c modified +12 −4
src/backend/commands/tablecmds.c modified +30 −28
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 +7 −29
src/backend/storage/smgr/smgr.c modified +0 −35
src/backend/utils/cache/relcache.c modified +52 −228
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 −2
src/include/access/gistxlog.h modified +0 −1
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