Re: Unaccounted regression from postgresql 11 in later versions

2023-05-31 Thread Bob Jolliffe
Wow Michael you are absolutely right. Turning jit off results in a query execution about twice as fast as pg11. That is a huge relief. I will read the jit related docs and see if there is anything smarter I should be doing other than disabling jit entirely, but it works a treat for this query.

Re: Unaccounted regression from postgresql 11 in later versions

2023-05-31 Thread Michael Christofides
> > Does anyone have a theory of why pg15 should behave so differently to pg11 > here? Better still, any suggestions for configuration that might make pg15 > behave more like pg10. I am really dreading the prospect of stepping our > many live implementations back to pg11 :-(. > One major factor