Is there a postgres extension or project related to application-level/foreign-table data caching ? The postgres_fdw extension fetches data from foreign table for each command.
I have seen previous messages in archive about caching in form of global temp tables, query cache etc. There are good discussions about whether support should be built-in but did not find any implementation.
I have seen the 44 postgres extensions that come pre-installed with ubuntu 16.04 but none of them do this.