There is pgvectorscale from timescale which uses disk ann based data structure and has support for pre and post filtering.
I mention this towards the end of the post. it looks like a good solution, but it's not available on RDS
I mention this towards the end of the post. it looks like a good solution, but it's not available on RDS