On Fri, Jan 31, 2020 at 11:44 AM Anton Aylward <opensuse@antonaylward.com> wrote:
On 2020-01-30 11:21 p.m., medwinz wrote:
Anyway I try to avoid disk swap on my database, and push it to use hugepages and TLB extensively. I also use zram and change the unused RAM become swap.
Could you detail each of those two matters, please.
Hi, There are many sources on the internet, postgresql documentation mentions it on https://www.postgresql.org/docs/12/kernel-resources.html#LINUX-HUGE-PAGES I made an article in indonesia openSUSE community blog (but it is in Indonesian language) https://opensuse.id/2020/01/04/tuning-konfigurasi-postgresql/ For zram it is very straight forward just install it from official repo, configure it, and start the service. best, -- Edwin -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org