Tunning Server 9.1. - Mailing list pgsql-general

From Periko Support
Subject Tunning Server 9.1.
Date
Msg-id CAK2yrTbOa8+CoU6yCmfeeXbfWsQHPfGw+jB_6mf97n24GQQoBQ@mail.gmail.com
Whole thread Raw
Responses Re: Tunning Server 9.1.  (John R Pierce <pierce@hogranch.com>)
List 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


pgsql-general by date:

Previous
From: Venkata Balaji N
Date:
Subject: Re: Question about wal files / pg_xlogs
Next
From: John R Pierce
Date:
Subject: Re: Question about wal files / pg_xlogs