On Sun, Feb 24, 2019 at 5:03 PM Alexander Korotkov <a.korot...@postgrespro.ru> wrote: > On Wed, Jan 30, 2019 at 5:28 AM Andres Freund <and...@anarazel.de> wrote: > > Why -CF, and why is -p repeated? > > BTW, for our SQL grammar we have > > > scan.c: FLEXFLAGS = -CF -p -p > > Is it kind of default?
I just saw this in the committed patch. This is not default, it's chosen for maximum performance at the expense of binary/memory size. That's fine, but with a little effort you can also make the scanner non-backtracking for additional performance, as in the attached. -- John Naylor https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
jsonpath-scan-nobackup.patch
Description: Binary data