| From: | Periko Support <pheriko(dot)support(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Tunning Server 9.1. |
| Date: | 2016-08-04 05:13:05 |
| Message-ID: | CAK2yrTbOa8+CoU6yCmfeeXbfWsQHPfGw+jB_6mf97n24GQQoBQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi.
I have server that hras increase users and need to increase
max_connections from default value.
Current value = 100
New Value = 200
This send me a message about shared_memory need to lower the value
which default settings = 24MB.
My server has 128GB in size, for 200 connections what settings and
values u recommend for my server?
I'm reading tunning just would like to receive tips an suggestions.
Reading docs looks like if I lower shared_buffers will affect my
performance?, right now is 12MB, bigger values won't allow me to
increase max_connections.
Any comment will be appreciated, thanks.
Linux Ubuntu 12.
Postgresql 9.1.x
x64.
128GB RAM
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2016-08-04 06:00:05 | Re: Question about wal files / pg_xlogs |
| Previous Message | Venkata Balaji N | 2016-08-04 04:08:29 | Re: Question about wal files / pg_xlogs |