Hello PG Devs,
For an extension I am working on. I want to create a new storage access method. To do this, I would like/need to get scan_keys passed to table_beginscan in SeqNext. For reference, the comments in SeqRecheck
/*
* Note that unlike IndexScan, SeqScan never use keys in heap_beginscan
* (and this is very bad) - so, here we do not check are keys ok or not.
*/
Is there a plan to have scan keys passed to table_beginscan in SeqNext? and if not, is there a reason why? I know the heap access method has support for it.
I am trying to build a key/value access method for a very specific use case and this seems to be my best option. I don't want to use an index because part of the goal of adding this access method to the project is to reduce write amplification of updates, and to make that work with an index would be much more sophisticated and I feel would be more likely to break.
Thank You,
Josh Innis