Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 61DDB9FA492 for ; Wed, 20 Dec 2006 01:42:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 35532-05 for ; Wed, 20 Dec 2006 01:41:56 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc1-s18.bay0.hotmail.com (bay0-omc1-s18.bay0.hotmail.com [65.54.246.90]) by postgresql.org (Postfix) with ESMTP id C34699FB25D for ; Wed, 20 Dec 2006 01:31:22 -0400 (AST) Received: from BAY121-W16 ([207.46.10.51]) by bay0-omc1-s18.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Tue, 19 Dec 2006 21:31:21 -0800 X-Originating-IP: [200.116.135.18] X-Originating-Email: [arcila_alvaro@hotmail.com] Message-ID: Content-Type: multipart/alternative; boundary="_443935bc-4e05-428c-96c1-09f341d0b8bc_" From: ALVARO ARCILA To: Subject: max_fsm_pages and check_points Date: Wed, 20 Dec 2006 05:31:21 +0000 MIME-Version: 1.0 X-OriginalArrivalTime: 20 Dec 2006 05:31:21.0536 (UTC) FILETIME=[150CA400:01C723F8] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200612/483 X-Sequence-Number: 22539 --_443935bc-4e05-428c-96c1-09f341d0b8bc_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable HI, =20 I've looking around the log files of my server and lately they indicate tha= t I should consider increase the check_point segments because they're beein= g reading too often and also recommend increasing the max_fsm_pages over 16= 9728... =20 those are the config values present in the postgresql.conf =20 shared_buffers =3D 1000 # min 16 or max_connect= ions*2, 8KB eachwork_mem =3D 8192 # min 64= , size in KBmaintenance_work_mem =3D 262152 # min 1024, size in K= Bmax_fsm_pages =3D 40000 # min max_fsm_relations*1= 6, 6 bytes eachmax_fsm_relations =3D 2000 # min 100,= ~70 bytes each =20 =20 And the new values, acording to the HNIT in log files ... =20 shared_buffers =3D 1000 # min 16 or max_connect= ions*2, 8KB eachwork_mem =3D 8192 # min 64= , size in KBmaintenance_work_mem =3D 262152 # min 1024, size in K= Bmax_fsm_pages =3D 170000 # min max_fsm_relations*16= , 6 bytes eachmax_fsm_relations =3D 10625 # min 100, ~= 70 bytes each =20 =20 =20 _________________________________________________________________ Consigue el nuevo Windows Live Messenger http://get.live.com/messenger/overview= --_443935bc-4e05-428c-96c1-09f341d0b8bc_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
HI,
 
I've looking around the log files of my server and lately they indicate tha= t I should consider increase the check_point segments because they're beein= g reading too often and also recommend increasing the max_fsm_pages over 16= 9728...
 
those are the config values present in the postgresql.conf
 
shared_buffers =3D 1000        &nbs= p;            &= nbsp;       # min 16 or max_connections*2, 8K= B each
work_mem =3D 8192        =             &nb= sp;            =  # min 64, size in KB
maintenance_work_mem =3D 262152  &n= bsp;        # min 1024, size in KB
ma= x_fsm_pages =3D 40000          = ;            &n= bsp;   # min max_fsm_relations*16, 6 bytes each
max_fsm_relati= ons =3D 2000           &n= bsp;            # mi= n 100, ~70 bytes each
 
 
And the new values, acording to the HNIT in log files ...
 
shared_buffers =3D 1000        &nbs= p;            &= nbsp;       # min 16 or max_connections*2, 8K= B each
work_mem =3D 8192        =             &nb= sp;            =  # min 64, size in KB
maintenance_work_mem =3D 262152  &n= bsp;        # min 1024, size in KB
ma= x_fsm_pages =3D 170000         = ;            &n= bsp;  # min max_fsm_relations*16, 6 bytes each
max_fsm_relations = =3D 10625           =            # min 100, ~70= bytes each
 
 
 


Consigue el nuevo Windows Live Messenger Pru=E9balo = --_443935bc-4e05-428c-96c1-09f341d0b8bc_--