Re: Parallel hints in PostgreSQL with consistent perfromance

Поиск
Список
Период
Сортировка
От Matheus de Oliveira
Тема Re: Parallel hints in PostgreSQL with consistent perfromance
Дата
Msg-id CAJghg4JT1vOhKqRT1QxCmpDS0Ki6Q+oSKwKytfVqQw0f4_Abjw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Parallel hints in PostgreSQL with consistent perfromance  (mohini mane <mohini.android@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: mohini mane
Дата:
Сообщение: Re: Parallel hints in PostgreSQL with consistent perfromance
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Parallel hints in PostgreSQL with consistent perfromance