Re: [PATCHES] GIN improvements

Teodor Sigaev <teodor(at)sigaev(dot)ru> writes:
> - GiST already supports both scan directions in theory, but page split may
> change order between forward and backward scans (user-defined pageSplit doesn't
> preserve order of tuples). Holding of split until end of scan will produce
> unacceptable concurrency level.

> - GIN doesn't support backward scan direction and will not support in close
> future.

Okay. I'll see about fixing the planner to not assume that GIST or GIN
indexscans are scrollable.

The cleanest way to do this is to introduce a new bool column in pg_am
rather than hard-wiring assumptions about which AMs can do it. However
(a) that's not back-patchable and (b) it'll create a merge conflict with
your patch, if you're still going to add a new AM function column.
I think that aminsertcleanup per se isn't needed, but if we want an
"amanalyze" there'd still be a conflict. Where are we on that?

regards, tom lane