Parallel hints with pg_hint_plan extension not working with DML operations

From: mohini mane <mohini(dot)android(at)gmail(dot)com>
To: pgsql-in-general(at)lists(dot)postgresql(dot)org
Subject: Parallel hints with pg_hint_plan extension not working with DML operations
Date: 2024-01-19 13:34:00
Message-ID: CA+NBJdkM8K=eGQCwF3C1EqV3nvHGp4T_T0Vjkfi3_KhqXktLyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-in-general

Hi ,
Can someone help me with the mailing address [email id] to discuss the
observation with pg_hint_plan parallel hints in DML operations,however
parallel hint works perfectly fine with SELECT query on the same table?

Sharing observation details: Please let me know who will be the correct
team to discuss this issue/observation.

As per my test runs I observed that parallel hints are not used by
pg_hint_plan to run UPDATE,DELETE or INSERT operations.

postgres=# EXPLAIN ANALYZE UPDATE /*+ PARALLEL("A" 5 hard) */ "test1" "A"
SET "cust_gender"='F' WHERE "cust_gender" <>'F';
NOTICE: pg_hint_plan:
used hint:

*not used hint:Parallel(A 5 hard)*
duplication hint:
error hint:

QUERY PLAN
-----------------------------------------------------------------------------------------------------------------
Update on test1 "A" (cost=0.00..26030.00 rows=1 width=420) (actual
time=95.295..95.297 rows=0 loops=1)
-> Seq Scan on test1 "A" (cost=0.00..26030.00 rows=1 width=420)
(actual time=95.291..95.291 rows=0 loops=1)
Filter: (cust_gender <> 'F'::bpchar)
Rows Removed by Filter: 200000
Planning Time: 126.908 ms
Execution Time: 95.518 ms

Thanks,
Mohini

Browse pgsql-in-general by date

  From Date Subject
Next Message SUMIT FADALE 2024-02-18 05:59:18 Issue while calling the procedure
Previous Message Tanya Mital 2022-06-02 11:53:34 Roadmap around PostgreSQL's search results ranking