开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜