Does Postgres provide a command to flush buffer cache?

Question

Hi Sometimes I need to do some SQL tuning task, I usually do such tests on my test db. After I excute a sql statments, I want to flush the buffer cache which containing SQL statements and sql result, just like the command in Oracle "Alter system flush buffer_cache"
Is PG server provide a commond of this?

possible duplicate of See and clear Postgres caches/buffers? — Louis
– Louis, Commented Apr 15, 2015 at 19:03

user99874 · Accepted Answer · 2013-08-14 18:31:54Z

3

If you're developing on OSX (I haven't tested on linux), you can use purge command to force disk cache to be purged (flushed and emptied). Then run your SQL query again and it should execute as if it were the first time.

answered Aug 14, 2013 at 18:31

user99874

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

Collectives™ on Stack Overflow

Does Postgres provide a command to flush buffer cache?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related