Re: [HACKERS] WAL logging problem in 9.4.3?

Kyotaro Horiguchi <horikyota.ntt@gmail.com>

From: Kyotaro Horiguchi <horikyota.ntt@gmail.com>

To: noah@leadboat.com

Cc: robertmhaas@gmail.com, pgsql-hackers@postgresql.org, 9erthalion6@gmail.com, andrew.dunstan@2ndquadrant.com, hlinnaka@iki.fi, michael@paquier.xyz

Date: 2019-12-04T04:47:35Z

Lists: pgsql-hackers

Attachments

benchmark_scripts.tar.gz (application/octet-stream)
result.txt.gz (application/octet-stream)
summary.txt.gz (application/octet-stream)
graph.png (image/png)

At Tue, 03 Dec 2019 20:51:46 +0900 (JST), Kyotaro Horiguchi <horikyota.ntt@gmail.com> wrote in 
> I'll send the complete data tomorrow (in JST). The attached f.txt is
> the result of preliminary test only with pages=100 and 250 (with HDD).

The attached files are the latest set of the test scripts and the result:
  benchmark_scripts.tar.gz
     benchmain.sh    - main script
     bench2.sh       - run a benchmark with a single set of parameters
     bench1.pl       - behchmark client program
     summarize.pl    - script to summarize benchmain.sh's output
     graph.xlsx         - MS-Excel file for the graph below.
  result.txt.gz      - raw result of benchmain.sh
  summary.txt.gz     - cooked result by summarize.pl -s
  graph.png          - graphs

summarize.pl [-v|-s|-d]
   -s: print summary table for spreadsheets (TSV)
   -v: show pgbench summary
   -d: debug print

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center

Commits

Add perl2host call missing from a new test file.
- 70de4e950c3b 13.0 landed
Skip WAL for new relfilenodes, under wal_level=minimal.
- c6b92041d385 13.0 landed
- 9db4b9da2801 9.5.22 landed
- a653bd8aa76e 9.6.18 landed
- 9d6215205e5a 10.13 landed
- 03b89f1949a9 11.8 landed
- e4b0a02ef8c8 12.3 landed
- cb2fd7eac285 13.0 landed
Revert "Skip WAL for new relfilenodes, under wal_level=minimal."
- b31e96ba420f 9.5.22 landed
- 348f15e22e94 9.6.18 landed
- 0a6c9c66da26 10.13 landed
- 63631ee64f84 12.3 landed
- 2fbdebc248ec 11.8 landed
- de9396326edc 13.0 landed
Back-patch log_newpage_range().
- e0dd086414f7 9.5.22 landed
- 14d2bb4941e6 9.6.18 landed
- 43434ed94d80 10.13 landed
- ae86e46c3b7b 11.8 landed
During heap rebuild, lock any TOAST index until end of transaction.
- a8f754aea014 9.6.18 landed
- 978da2a95597 9.5.22 landed
- 78a34c68920a 10.13 landed
- 88b3a6cd2623 12.3 landed
- 4433c6e8c0a5 11.8 landed
- e629a01f6973 13.0 landed
In log_newpage_range(), heed forkNum and page_std arguments.
- a5abec521c5d 12.3 landed
- d3e572855be1 13.0 landed
Back-patch src/test/recovery and PostgresNode from 9.6 to 9.5.
- 12034da6cc39 9.5.22 landed
Reduce pg_ctl's reaction time when waiting for postmaster start/stop.
- c61559ec3a41 10.0 cited
Accelerate end-of-transaction dropping of relations
- 279628a0a7cf 9.3.0 cited
Redesign the planner's handling of index-descent cost estimation.
- 31f38f28b00c 9.3.0 cited
Make TRUNCATE do truncate-in-place when processing a relation that was created
- cab9a0656c36 9.0.0 cited