I use windows server 2012 R2.
How to drop postgresql's data in the system cache.
In windows server 2012 R2, I restart postgresql by restarting postgresql
service, wether it can drop postgres' cache?
At 2018-09-26 22:52:08, "Maxence Ahlouche" wrote:
Hi,
On 26 September 2018 at 08:25, ji
Hi,
On 26 September 2018 at 08:25, jimmy wrote:
> 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:
>
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 lo
