effective_cache_size and work_ram

From: "ac(at)hsk(dot)hk" <ac(at)hsk(dot)hk>
To: "pgsql-general(at)postgresql(dot)org general" <pgsql-general(at)postgresql(dot)org>
Cc: ac(at)hsk(dot)hk
Subject: effective_cache_size and work_ram
Date: 2012-12-12 07:26:50
Message-ID: 06850D76-E49E-42E3-9897-02618C6F1EA8@hsk.hk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a new server for PostgreSQL 9.2.2 with 8GB physical RAM, I want to turn the server with the following changes from default:

max_connections = 100 # default
shared_buffers = 2048MB # change from 24MB to 2048MB as I think 24MB is not enough
maintenance_work_mem = 400MB # 50MB/GB x 8GB
effective_cache_size = 4096MB # Set to 50% of total RAM
work_mem = 24MB
checkpoint_segments = 10
wal_buffers = 16MB

Are these values reasonable?

Thanks
ac

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2012-12-12 07:55:25 Re: effective_cache_size and work_ram
Previous Message Fan, Yi 2012-12-12 01:21:01 Re: Looking for cooperators