Home > mailing lists

effective_cache_size and work_ram - Mailing list pgsql-general

From	ac@hsk.hk
Subject	effective_cache_size and work_ram
Date	December 12, 2012 10:27:09
Msg-id	06850D76-E49E-42E3-9897-02618C6F1EA8@hsk.hk Whole thread Raw
In response to	Re: large database (David Boreham <david_list@boreham.org>)
Responses	Re: effective_cache_size and work_ram
List	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

From: Adrian Klaver
Date: 12 December 2012, 01:26:02
Subject: Re: large database

From: Pavel Stehule
Date: 12 December 2012, 10:56:08
Subject: Re: effective_cache_size and work_ram