Re: [HACKERS] WAL logging problem in 9.4.3?

From: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
To: noah(at)leadboat(dot)com
Cc: robertmhaas(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org, 9erthalion6(at)gmail(dot)com, andrew(dot)dunstan(at)2ndquadrant(dot)com, hlinnaka(at)iki(dot)fi, michael(at)paquier(dot)xyz
Subject: Re: [HACKERS] WAL logging problem in 9.4.3?
Date: 2019-12-04 04:47:35
Message-ID: 20191204.134735.906643794665403860.horikyota.ntt@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At Tue, 03 Dec 2019 20:51:46 +0900 (JST), Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)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

Attachment Content-Type Size
benchmark_scripts.tar.gz application/octet-stream 38.6 KB
result.txt.gz application/octet-stream 108.9 KB
summary.txt.gz application/octet-stream 3.1 KB
image/png 46.4 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2019-12-04 04:55:23 Re: Using XLogFileNameP in critical section
Previous Message Stephen Frost 2019-12-04 04:08:12 Re: [HACKERS] Incomplete startup packet errors