Hi Amit! It's a pity I missed this thread when you developed the patch. I've developed a feature recently and discovered that SeqScan does not make use of scan keys, and there is a Tom Lane's comment regarding this: * 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.
Have you considered passing scan keys like it is done in IndexScan? Thanks! -- Regards, Nikita Malakhov Postgres Professional The Russian Postgres Company https://postgrespro.ru/