Hi Jeff,
Insert SQL:
INSERT INTO test_indexes (bool_data , int_data , text_data ) VALUES ( (RANDOM() * 10)::INT % 2 = 0, RANDOM() * 10000, MD5((RANDOM() * 1000)::TEXT) );
pg_bench:
/usr/pgsql-11/bin/pgbench -Upostgres -f ${SQL} -n -c 60 -j 60 -T120 -p ${PORT}
Before each test run, I drop and recreate the table and indexes.
Cheers,
Paolo
The following bug has been logged on the website:
Bug reference: 15609
Logged by: Jean Paolo Saul
Email address: paolo.saul@verizonconnect.com
PostgreSQL version: 11.1
Operating system: CentOS Linux release 7.6.1810 (Core)
Description:
Summary:
We are considering upgrading to PG11 and during performance testing we
have found that
PostgreSQL 11 inserts are around 25% slower than inserts in PostgreSQL
9.5.
Tools Used:
pgbench (11.1)
Can you show the actual pgbench command line used, and the contents of the file specified by -f ?
Cheers,
Jeff
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.