how to clean the cache from databases and operating system - Mailing list pgsql-general

From jimmy
Subject how to clean the cache from databases and operating system
Date
Msg-id 7d8b4bf.730b.166148e39d5.Coremail.mpokky@126.com
Whole thread Raw
Responses Re: how to clean the cache from databases and operating system  (Maxence Ahlouche <maxence.ahlouche@gmail.com>)
List pgsql-general
1、When I execute the firse sql query, like below:
     select * from tablename;
     there are some datas that will be loaded into the database cache.
     How to clean the data from cache.
2、When I execute second sql query like below:
     SELECT pg_prewarm('tablename', 'buffer') . Data will be loaded into the  database cache.
     How to clean the data from cache.
3、When I execute the third sql query like below:
     SELECT pg_prewarm('tablename', 'main') . Data will be loaded into the  os  cache.
     How to clean the data from cache.



 

pgsql-general by date:

Previous
From: jimmy
Date:
Subject: Re:Re: how to know whether query data from memory after pg_prewarm
Next
From: Yuri Kanivetsky
Date:
Subject: Setting up continuous archiving