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
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 |