PostgreSQL 9.3.2 Performance tuning for 32 GB server

From: RAMAKRISHNAN KANDASAMY <ramky24(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: PostgreSQL 9.3.2 Performance tuning for 32 GB server
Date: 2014-01-25 06:32:59
Message-ID: CADG-hT+JYGzV3fteXBDO2V1=kgkAFzMm0Ouq8tWm=UMNiqMrGg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi All,

I have configured the blow parameters for a 32 GB server . I this correct ?

shared_buffers = 6GB
work_mem = 24MB maintenance_work_mem = 250MB
effective_cache_size = 16GB
shared_preload_libraries = 'pg_stat_statements' pg_stat_statements.max =
10000 pg_stat_statements.track = all
wal_buffers = 8MB
checkpoint_segments = 32
checkpoint_completion_target = 0.9

--
--Regards
RAMAKRISHNAN KANDASAMY

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bongseo Jang 2014-01-27 05:58:41 self join, parameterized base/join rel path row estimation and generally...
Previous Message Josh Kupershmidt 2014-01-24 21:42:42 Re: pg_repack solves alter table set tablespace lock