Re: Keeping some tables in cache

2025-08-26 Thread Laurenz Albe
On Tue, 2025-08-26 at 11:21 +0300, Ertan Küçükoglu wrote: > I am using PostgreSQL 17.6 on Win64 platform running on VPS with 4 cores > (2.59Ghz Xeon SapphireRapids) and 4GB RAM. > On average 1.7 to 2.0GB of RAM is actively used on that server. > Disk performance is not great at all. > I have no oth

Re: Keeping some tables in cache

2025-08-26 Thread Achilleas Mantzios
On 8/26/25 09:21, Ertan Küçükoglu wrote: Hello, I read a lot of different suggestions on the web and finally confused and decided to ask in here. Same/similar questions are asked before like 14 years ago 7 years ago, etc. and I also wanted to learn the latest news. I am using PostgreSQL 17

Keeping some tables in cache

2025-08-26 Thread Ertan Küçükoglu
Hello, I read a lot of different suggestions on the web and finally confused and decided to ask in here. Same/similar questions are asked before like 14 years ago 7 years ago, etc. and I also wanted to learn the latest news. I am using PostgreSQL 17.6 on Win64 platform running on VPS with 4 cores