Re: Parallel query behaving different with custom GUCs

2023-11-08 Thread Michael Paquier
On Mon, Oct 30, 2023 at 09:21:56AM -0400, Robert Haas wrote: > I'm also alert to my own possible bias. Perhaps since I designed this > mechanism, I'm more prone to viewing its deficiencies as minor than a > neutral observer would be. So if anyone is sitting there reading this > and thinking "wow,

Re: Parallel query behaving different with custom GUCs

2023-10-30 Thread Robert Haas
On Thu, Oct 26, 2023 at 3:10 AM Rushabh Lathia wrote: > -- RESET the custom GUC and rerun the query. > postgres=> reset myapp.blah; > RESET > > -- Query should still run, but with forcing parallel plan, throwing an error. > postgres=> select count(*) from ptest2 where

Parallel query behaving different with custom GUCs

2023-10-26 Thread Rushabh Lathia
Hi All, We observed the behavioral difference when query(with custom GUC) using the PARALLEL plan vs the Non-PARALLEL plan. Consider the below test: I understand the given testcase doesn't make much sense, but this is the simplest version of the test - to demonstrate the problem. create table