execution time slow down PGv14 compared with PGv13
On Thu, 15 Dec 2022 at 21:12, James Pang (chaolpan) wrote:
>We had some load test ( DML inserts/deletes/updates/ on tens of hash
> partition tables) and found that PGV14 slow down 10-15% compared with PGV13.
> Same test server, sa
Did you check pg_stat_statements ? looks like select some better , but DML
decreased.
-Original Message-
From: David Rowley
Sent: Thursday, December 15, 2022 6:42 PM
To: James Pang (chaolpan)
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: DML sql execution time slow down
On Thu, 15 Dec 2022 at 21:12, James Pang (chaolpan) wrote:
>We had some load test ( DML inserts/deletes/updates/ on tens of hash
> partition tables) and found that PGV14 slow down 10-15% compared with PGV13.
> Same test server, same schema tables and data. From pg_stat_statements, sql
> e
.postgresql.org>
Subject: Re: DML sql execution time slow down PGv14 compared with PGv13
Hello James,
Could you please add configurations of your PostgreSQL installations too?
I also wonder why you skip vacuuming (-n parameter) before starting of tests.
Best regards.
Samed YILDIRIM
On Thu, 15
, primary keys 640.91 s).
Thanks,
James
From: Samed YILDIRIM
Sent: Thursday, December 15, 2022 4:38 PM
To: James Pang (chaolpan)
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: DML sql execution time slow down PGv14 compared with PGv13
Hello James,
Could you please add configurations
Hello James,
Could you please add configurations of your PostgreSQL installations too?
I also wonder why you skip vacuuming (-n parameter) before starting of
tests.
Best regards.
Samed YILDIRIM
On Thu, 15 Dec 2022 at 10:22, James Pang (chaolpan)
wrote:
> Hi,
>
>We had some load test ( DML
