get result of search in database postgresql and work with it every time

I have a query who spend alot of time because there is thousand of ligne in the database, so I need if it’s exist a method to put the result of the query some where and work with them the time i want. thanks

From PostgreSQL’s point of view you can use Materialized Views or Unlogged Tables

For other solutions you can check different caching mechanisms