Search Postgresql Archives

how to clean the cache from databases and operating system

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.



 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux