X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1B9DD3A3AE8 for ; Mon, 3 Jan 2005 08:16:28 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 12889-01 for ; Mon, 3 Jan 2005 08:16:18 +0000 (GMT) Received: from webmail.moph.go.th (health.moph.go.th [203.157.0.1]) by svr1.postgresql.org (Postfix) with SMTP id D13DB3A3AE7 for ; Mon, 3 Jan 2005 08:16:17 +0000 (GMT) Received: (qmail 18687 invoked from network); 3 Jan 2005 08:18:57 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by localhost with SMTP; 3 Jan 2005 08:18:57 -0000 Received: from webmail.moph.go.th ([127.0.0.1]) by localhost (webmail.moph.go.th [127.0.0.1]) (amavisd-new, port 10024) with SMTP id 16555-44 for ; Mon, 3 Jan 2005 15:18:56 +0700 (ICT) Received: (qmail 18674 invoked from network); 3 Jan 2005 08:18:56 -0000 Received: from unknown (HELO localhost) (203.157.0.1) by health.moph.go.th with SMTP; 3 Jan 2005 08:18:56 -0000 Received: from 203.157.100.42 ([203.157.100.42]) by webmail.moph.go.th (IMP) with HTTP for ; Mon, 3 Jan 2005 15:18:56 +0700 Message-ID: <1104740336.41d8fff03ff3a@webmail.moph.go.th> Date: Mon, 3 Jan 2005 15:18:56 +0700 From: amrit@health2.moph.go.th To: Mark Kirkwood Cc: PGsql-performance Subject: Re: Low Performance for big hospital server .. References: <1104634472.41d762681b548@webmail.moph.go.th> <20050102140828.GA21826@pobox.com> <1104683293.41d8211d62221@webmail.moph.go.th> <41D8AD42.1010806@coretech.co.nz> <1104728050.41d8cff2b2b29@webmail.moph.go.th> <41D8E406.1090501@coretech.co.nz> In-Reply-To: <41D8E406.1090501@coretech.co.nz> MIME-Version: 1.0 Content-Type: text/plain; charset=TIS-620 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.3 X-Originating-IP: 203.157.100.42 X-Virus-Scanned: by amavisd-new at moph.go.th X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200501/10 X-Sequence-Number: 9700 > shared_buffers = 12000 will use 12000*8192 bytes (i.e about 96Mb). It is > shared, so no matter how many connections you have it will only use 96M. Now I use the figure of 27853 > > > >Will the increasing in effective cache size to arround 200000 make a little > bit > >improvement ? Do you think so? > > Decrease the sort mem too much [8196] make the performance much slower so I use sort_mem = 16384 and leave effective cache to the same value , the result is quite better but I should wait for tomorrow morning [official hour] to see the end result. > > > I would leave it at the figure you proposed (128897), and monitor your > performance. > (you can always increase it later and see what the effect is). Yes , I use this figure. If the result still poor , putting more ram "6-8Gb" [also putting more money too] will solve the problem ? Thanks , Amrit Thailand