PostgreSQL equivalent to "SET SESSION query_cache_type = ON/OFF";
I just wanted to know what's the equivalent query in PostgreSQL to MySQL's
SET SESSION query_cache_type = ON SET开发者_如何学C SESSION query_cache_type = OFF
There is no equivalent. PostgreSQL has a very different internal architecture from MySQL and its caching ("shared buffers") works on another level. It does not store query results, but rather the data which is needed to compute those results (query plans and tables, basically).
https://www.postgresql.org/docs/current/static/runtime-config-resource.html
https://www.postgresql.org/message-id/14010534715277@mail.emproshunts.com
http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg109033.html
精彩评论