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
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/de9396326edcbe5cafc06a72016f9d715c350e0e

Modified Files
--------------
contrib/pg_visibility/expected/pg_visibility.out |  35 ---
contrib/pg_visibility/sql/pg_visibility.sql      |  19 --
doc/src/sgml/config.sgml                         |  39 +--
doc/src/sgml/perform.sgml                        |  47 ++-
src/backend/access/gist/gistutil.c               |  31 +-
src/backend/access/gist/gistxlog.c               |  21 --
src/backend/access/heap/heapam.c                 |  45 ++-
src/backend/access/heap/heapam_handler.c         |  22 +-
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                    | 246 +--------------
src/backend/commands/cluster.c                   |  19 --
src/backend/commands/copy.c                      |  58 +++-
src/backend/commands/createas.c                  |  11 +-
src/backend/commands/indexcmds.c                 |   2 -
src/backend/commands/matview.c                   |  12 +-
src/backend/commands/tablecmds.c                 |  26 +-
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               | 268 ++++------------
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                      |   3 +
src/include/access/rewriteheap.h                 |   2 +-
src/include/access/tableam.h                     |  15 +-
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                          |  55 +---
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 -
51 files changed, 363 insertions(+), 1439 deletions(-)