Re: How to gracefully keep my specific index in memory ?

2019-08-12 Thread James(王旭)
? -- Original -- From: "Laurenz Albe"; Date: Mon, Aug 12, 2019 08:24 PM To: "James(王旭)"; "pgsql-general"; Subject: Re: How to gracefully keep my specific index in memory ? James(王旭) wrote: > As the title,How to keep a sp

Re: How to gracefully keep my specific index in memory ?

2019-08-12 Thread Laurenz Albe
James(王旭) wrote: > As the title,How to keep a specific index in memory gracefully? > > After some statistical query, I can determine that not all indexes can be fit > into memory, > but one of the most frequently used indexes(say idx_xyz) can be definitely > fit into > memory(specifically ,[the

How to gracefully keep my specific index in memory ?

2019-08-12 Thread James(王旭)
Hello: As the title,How to keep a specific index in memory gracefully? After some statistical query, I can determine that not all indexes can be fit into memory, but one of the most frequently used indexes(say idx_xyz) can be definitely fit into memory(specifically ,[the size of idx_xyz]=20%