From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: anilbommareddy09@gmail.com
Subject: BUG #17153: tpch-hammerdb-Query21
Date: Wed, 18 Aug 2021 06:11:59 +0000
Message-ID: <17153-bd309320429d24b7@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17153
Logged by: bommareddy
Email address: anilbommareddy09@gmail.com
PostgreSQL version: 13.3
Operating system: RHEL8.3
Description:
In PostgreSQL13.3 , tried to run tpch with Hammedb benchmark environment .
Observed Q17,Q20, Q21 executed long period time .
Q17--->5000 seconds
Q20--->6124 seconds
Q21--->53271 seconds.
the issue was may not observe with pervious/older PostgreSQL version like
12.x
Run the following commands in sequence to load data
Hammerdb4.x]./hammerdbcli
>dbset db pg #Configure the database type.
>dbset bm tpc-h #Configure the test model.
>diset connection pg_host localhost #Configure the database service
address.
>diset tpch pg_tpch_superuser gpadmin #Configures the database superuser.
>diset tpch pg_tpch_superuserpass 123456 #Configures the database superuser
password.
>diset tpch pg_tpch_defaultdbase postgres #Configures the default superuser
database
>diset tpch pg_scale_fact 1 #Configure data volume. The default value is
1.
>diset tpch pg_num_tpch_threads 30 #Configure the number of concurrent
threads.
>diset tpch pg_tpch_gpcompat true #Enable Greenplum-compatibility.
>diset tpch pg_tpch_gpcompress true #Enable Greenplum parameters.
>buildschema
"ALL VIRTUAL USERS COMPLETE" is returned, indicating that the data is
imported successfully.
Perform the test. in hammerdbcli
>vuset vu 1 #Configure the number of concurrent tasks.
>vuset showoutput 1 #Enable the log function.
>vuset logtotemp 1 #Enable the function of automatically saving logs to the
/tmp directory.
>vuset unique 1 #Configure log uniqueness, that is, logs are not
overwritten.
>print vuconf ##View the task configuration
Create a database on the database server and create a table based on the
test
model. You can view the OLAP test script in "src/postgresql/pgolap.tcl" in
the
HammerDB installation path
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, anilbommareddy09@gmail.com
Subject: Re: BUG #17153: tpch-hammerdb-Query21
In-Reply-To: <17153-bd309320429d24b7@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox