Re: Parallel hints in PostgreSQL with consistent perfromance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Tue, 2 Jan 2024, 21:45 David G. Johnston, <david.g.johnston@xxxxxxxxx> wrote:
On Tue, Jan 2, 2024 at 8:12 AM mohini mane <mohini.android@xxxxxxxxx> wrote:

I have executed the SELECT query with 2,4 & 6 parallel degree however every time only 4 workers launched & there was a slight increase in Execution time as well,

Adding an ignored comment to your SQL would not be expected to do anything.  So it is not surprising that it does not do anything about the number of workers launched.  It is just a comment.  A note to the human who is reading the code.
 >> As I am using pg_hint_plan extension so as expected hints should not get ignored by the optimizer .

Sounds like a bug you should go tell the pg_hint_plan authors about then.
    >> I am getting same results with or without extension [in my case it's pg_hint_plan] still I will check with the respective team, Thanks .

David J.


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux