Is there a way to exclude fields from a search in PostgreSQL?

Question

PostgreSQL

There is a large database in many tables of records over a million, when searching and fetching data, the DBMS still goes through all the records.
Please tell me, is there a way to exclude old or currently irrelevant records from the search so that even select is not performed on them?
Thanks in advance!

Answer 1

WHERE clause?

Answer 2

Optimize postgres settings
Simultaneously do explain
Then optimize the current query and index
If not enough, make the field is_searchable = boolean and add it to your queries