On Wed, 29 Jun 2022 at 00:45, Bos, Fred wrote:
> Finally, is there a way to force postgres to do the partial hash aggregate,
> either by changing a setting or by influencing the expected amount of output
> groups for each query?
You could do something like:
ALTER TABLE bhload_nohyp_noin ALTER
On Mon, 27 Jun 2022 at 23:49, Bos, Fred wrote:
> "Settings: effective_cache_size = '128GB', force_parallel_mode = 'on',
> max_parallel_workers = '40',
You shouldn't be using force_parallel_mode. It does not do what you
think. See the documentation for that GUC, or read [1]
> I expected the