Re: Parallel hints in PostgreSQL with consistent perfromance - Mailing list pgsql-performance

From Matheus de Oliveira
Subject Re: Parallel hints in PostgreSQL with consistent perfromance
Date
Msg-id CAJghg4JT1vOhKqRT1QxCmpDS0Ki6Q+oSKwKytfVqQw0f4_Abjw@mail.gmail.com
Whole thread Raw
In response to Re: Parallel hints in PostgreSQL with consistent perfromance  (mohini mane <mohini.android@gmail.com>)
List pgsql-performance


On Thu, Dec 28, 2023 at 9:47 AM mohini mane <mohini.android@gmail.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


pgsql-performance by date:

Previous
From: mohini mane
Date:
Subject: Re: Parallel hints in PostgreSQL with consistent perfromance
Next
From: "David G. Johnston"
Date:
Subject: Re: Parallel hints in PostgreSQL with consistent perfromance