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