Postgres Pro
Downloads
Home   >   mailing lists

PostgreSQL 9.3.2 Performance tuning for 32 GB server - Mailing list pgsql-performance

From RAMAKRISHNAN KANDASAMY
Subject PostgreSQL 9.3.2 Performance tuning for 32 GB server
Date
Msg-id CADG-hT+JYGzV3fteXBDO2V1=kgkAFzMm0Ouq8tWm=UMNiqMrGg@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL 9.3.2 Performance tuning for 32 GB server
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: jugnooken
Date:
Subject: Re: WHERE with ORDER not using the best index
Next
From: Dattaram Porob
Date:
Subject: Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6