Hi,
On 2018-10-17 09:48:19 +0300, Andrey Klychkov wrote:
> > Interesting. That's with an optimized build, or an assertion build?
>
> Hello,
> That was an optimized build.
>
> However I've just done some extra time tests and didn't notice so significant difference as early.
> Even more - avg origin 1272, avg patched 1303.
>
> Maybe there was the autovacuum / analyze / checkpoint or something else that could influence on the yesterday tests.
Probably worth looking at the generated code. I can see some difference,
but what you measured seemed pretty large.
Greetings,
Andres Freund