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

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

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/0a6c9c66da26751322d90f75c872c350376cf55e

Modified Files
--------------
doc/src/sgml/config.sgml | 41 +--
doc/src/sgml/perform.sgml | 47 +++-
src/backend/access/gist/gistbuild.c | 2 +-
src/backend/access/gist/gistutil.c | 31 +--
src/backend/access/gist/gistxlog.c | 21 --
src/backend/access/heap/heapam.c | 30 ++-
src/backend/access/heap/rewriteheap.c | 21 +-
src/backend/access/nbtree/nbtsort.c | 41 ++-
src/backend/access/rmgrdesc/gistdesc.c | 6 -
src/backend/access/transam/README | 45 +---
src/backend/access/transam/xact.c | 15 --
src/backend/access/transam/xlogutils.c | 18 +-
src/backend/bootstrap/bootparse.y | 4 -
src/backend/catalog/storage.c | 220 ---------------
src/backend/commands/cluster.c | 29 +-
src/backend/commands/copy.c | 64 ++++-
src/backend/commands/createas.c | 15 +-
src/backend/commands/matview.c | 16 +-
src/backend/commands/tablecmds.c | 56 ++--
src/backend/nodes/copyfuncs.c | 2 -
src/backend/nodes/equalfuncs.c | 2 -
src/backend/nodes/outfuncs.c | 2 -
src/backend/parser/gram.y | 4 -
src/backend/parser/parse_utilcmd.c | 4 -
src/backend/storage/buffer/bufmgr.c | 125 +--------
src/backend/storage/lmgr/lock.c | 12 -
src/backend/storage/smgr/md.c | 36 +--
src/backend/storage/smgr/smgr.c | 35 ---
src/backend/utils/cache/relcache.c | 280 ++++---------------
src/backend/utils/misc/guc.c | 12 -
src/backend/utils/misc/postgresql.conf.sample | 1 -
src/include/access/gist_private.h | 2 -
src/include/access/gistxlog.h | 1 -
src/include/access/heapam.h | 1 +
src/include/access/rewriteheap.h | 2 +-
src/include/catalog/storage.h | 6 -
src/include/nodes/parsenodes.h | 3 -
src/include/storage/bufmgr.h | 4 -
src/include/storage/lock.h | 3 -
src/include/storage/smgr.h | 1 -
src/include/utils/rel.h | 57 +---
src/include/utils/relcache.h | 8 +-
src/test/recovery/t/018_wal_optimize.pl | 372 --------------------------
src/test/regress/expected/alter_table.out | 6 -
src/test/regress/expected/create_table.out | 13 -
src/test/regress/sql/alter_table.sql | 7 -
src/test/regress/sql/create_table.sql | 15 --
47 files changed, 337 insertions(+), 1401 deletions(-)