Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes

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

On Wed, 30 Jan 2019 at 07:37, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:

> On Tue, Jan 29, 2019 at 12:46 AM PG Bug reporting form <
> noreply(at)postgresql(dot)org> wrote:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 15609
>> Logged by: Jean Paolo Saul
>> Email address: paolo(dot)saul(at)verizonconnect(dot)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.