| From: | Johnny Morano <johnny(dot)morano(at)payon(dot)com> |
|---|---|
| To: | Lucas Possamai <drum(dot)lucas(at)gmail(dot)com>, Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
| Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Increased I/O / Writes |
| Date: | 2016-05-17 08:04:25 |
| Message-ID: | D710C88BF90D514FACFEC1AEA215BD669CC34FDB@BO-VM-EXCHANGE1.office.payon.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
Why not use https://www.keithf4.com/a-large-database-does-not-mean-large-shared_buffers/ to determine your optimal shared_buffers settings? ;-)
Cheers
Johnny
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Lucas Possamai
Sent: Dienstag, 17. Mai 2016 06:12
To: Sergey Konoplev
Cc: Postgres General
Subject: Re: [GENERAL] Increased I/O / Writes
This is my postgresql.conf at the moment:
shared_buffer(51605MB) +
effective_cache_size(96760MB) +
work_mem(32MB) +
max_connections(200)
= 148397.08 MB
My server has 128GB of RAM
So, I'm using more RAM that I have. (not good at all)
I'm glad that it wasn't me who put those confs in there :)
Anyway...
I was thinking about decrease the shared_buffer to something like 1/8 of total RAM = 16GB
What do u guys think about it?
Cheers
Lucas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pierre Chevalier Géologue | 2016-05-17 08:25:55 | Re: Thoughts on "Love Your Database" |
| Previous Message | Martijn Tonies (Upscene Productions) | 2016-05-17 07:28:22 | Re: How to convert firebird stored procedures into postgresql functions |