On 30 Sep. 2016 19:36, "Emrul" <em...@emrul.com> wrote: > > Thanks Craig, I will look at that code. > > The alternative I'm considering is whether I can define my own index type on > the column storing my array of primary key ids. The index would, for each > primary key id just provide a reference to the ctids of the related records. > > In theory, I think this might be less work. However, I am yet to find a > simple/bare index implementation that I can build upon.
I don't think indexes are fully pluggable yet. And I'd be surprised if it were possible within GiST /GIN. Check out the 9.6 / v10 pg_am changes, which I think may be relevant. Or it could be an unrelated dead end because I know little about indexing. > > > > -- > View this message in context: http://postgresql.nabble.com/Learning-to-hack-Postgres-Keeping-track-of-ctids-tp5923649p5923757.html > Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers