Postgres Pro
Downloads
Home   >   mailing lists

max_fsm_pages and check_points - Mailing list pgsql-performance

From ALVARO ARCILA
Subject max_fsm_pages and check_points
Date
Msg-id BAY121-W16DAEF170C0B7B617356B083CF0@phx.gbl
Whole thread Raw
Responses Re: max_fsm_pages and check_points
List pgsql-performance
Tree view

HI,
 
I've looking around the log files of my server and lately they indicate that I should consider increase the check_point segments because they're beeing reading too often and also recommend increasing the max_fsm_pages over 169728...
 
those are the config values present in the postgresql.conf
 
shared_buffers = 1000                             # min 16 or max_connections*2, 8KB each
work_mem = 8192                                  # min 64, size in KB
maintenance_work_mem = 262152           # min 1024, size in KB
max_fsm_pages = 40000                          # min max_fsm_relations*16, 6 bytes each
max_fsm_relations = 2000                        # min 100, ~70 bytes each
 
 
And the new values, acording to the HNIT in log files ...
 
shared_buffers = 1000                             # min 16 or max_connections*2, 8KB each
work_mem = 8192                                  # min 64, size in KB
maintenance_work_mem = 262152           # min 1024, size in KB
max_fsm_pages = 170000                        # min max_fsm_relations*16, 6 bytes each
max_fsm_relations = 10625                      # min 100, ~70 bytes each
 
 
 

Consigue el nuevo Windows Live Messenger Pruébalo

pgsql-performance by date:

Previous
From: "Jeremy Haile"
Date:
Subject: Re: Inner join vs where-clause subquery
Next
From: Brian Herlihy
Date:
Subject: GROUP BY vs DISTINCT