Thanks for the tip Peter. Unfortunately it did not move the needle. Just curious what numbers are you getting when you are testing?
-------------------
PG9.5
tps = 37595.067794 (including connections establishing)
PG11
tps = 28709.328124 (including connections establishing)
On Tue, 12 Feb 2019 at 14:42, Peter Geoghegan <
pg@bowt.ie> wrote:
On Mon, Feb 11, 2019 at 5:36 PM Saul, Jean Paolo
<paolo.saul@verizonconnect.com> wrote:
> Using prepared and extended. No luck.
And your checkpoint settings?
The performance you're seeing is pretty bad for a server that has more
than 40GB of memory. I can get far superior performance on the same
benchmark with a relatively inexpensive workstation, at least on the
master branch.
Try these for a start if you're using default checkpoint settings, as
I suspect you are:
checkpoint_timeout=5min
min_wal_size=10GB
max_wal_size=40GB
wal_compression=on
backend_flush_after=0
checkpoint_flush_after=256kB
checkpoint_completion_target=0.9
--
Peter Geoghegan
PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS EMAIL
VERIZON CONNECT CONFIDENTIALITY NOTICE
This message is intended for the addressee only and may contain confidential and/or privileged material. Any review, re-transmission, dissemination, reliance upon or other use of this information by persons or entities other than the addressee is prohibited. If you receive this in error, please contact the sender and delete this message. Thank you.