PostgreSQL equivalent to "SET SESSION query_cache_type = ON/OFF";

Question

I just wanted to know what's the equivalent query in PostgreSQL to MySQL's

SET SESSION query_cache_type = ON SET SESSION query_cache_type = OFF

Why do you think you need something like this? What's your real problem? — Frank Heikens
– Frank Heikens, Commented May 25, 2010 at 11:36

MichielB · Accepted Answer · 2016-09-19 12:59:19Z

3

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/[email protected]

http://www.mail-archive.com/[email protected]/msg109033.html

edited Sep 19, 2016 at 12:59

MichielB

4,3441 gold badge33 silver badges39 bronze badges

answered May 23, 2010 at 13:23

leonbloy

76.4k22 gold badges149 silver badges197 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rfusca Over a year ago

I believe the only time PG caches a query plan is for a prepared statement - which causes a whole other set of issues.

Collectives™ on Stack Overflow

PostgreSQL equivalent to "SET SESSION query_cache_type = ON/OFF";

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related