| From: | Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com> |
|---|---|
| To: | mohini mane <mohini(dot)android(at)gmail(dot)com> |
| Cc: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Parallel hints in PostgreSQL with consistent perfromance |
| Date: | 2023-12-28 13:12:10 |
| Message-ID: | CAJghg4JT1vOhKqRT1QxCmpDS0Ki6Q+oSKwKytfVqQw0f4_Abjw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Dec 28, 2023 at 9:47 AM mohini mane <mohini(dot)android(at)gmail(dot)com>
wrote:
> Thank you for your response !!
> I am experimenting with SQL query performance for SELECT queries on large
> tables and I observed that changing/increasing the degree of parallel hint
> doesn't give the expected performance improvement.
>
Why do you believe you are changing the degree of parallelism? PostgreSQL
does not have parallel hints (or any hint in comments), so you are just
changing a comment in the queries, which changes nothing at all in the
execution plan.
Unless you are not using vanilla PostgreSQL or you have some extension in
place, in which case you didn't provide enough information.
Best regards,
--
Matheus de Oliveira
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2023-12-28 13:40:00 | Re: Parallel hints in PostgreSQL with consistent perfromance |
| Previous Message | mohini mane | 2023-12-28 12:46:59 | Re: Parallel hints in PostgreSQL with consistent perfromance |