SQL_NO_CACHE for Postgresql?

Question

Is there a postgresql equivalent for the MySQL SQL_NO_CACHE(or SQL Server dbcc drop clean buffers) keyword , i.e. you can just include in the SQL statement or as part of a script?

UPDATE : this question

See and clear Postgres caches / buffers?

the answer seems to be no, although he is now two years old. Are there any relevant changes in postgresql 9.0?

Answer 1

The two things you indicated are far from equivalent.

MySQL SQL_NO_CACHE DOES NOT block the use of cached data. This means that the query is not cached in the MySQL query cache.

- , , , , ( ..). , .

SQL_NO_CACHE , , , (, ).

MySQL , .. (. http://dom.as/tech/query-cache-tuner/)

Answer 2

, PostgreSQL - 100% .