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 123173A1A2E for ; Mon, 3 Jan 2005 01:51:38 +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 95941-03 for ; Mon, 3 Jan 2005 01:51:24 +0000 (GMT) Received: from webmail.moph.go.th (health.moph.go.th [203.157.0.1]) by svr1.postgresql.org (Postfix) with SMTP id 51EB83A2D30 for ; Mon, 3 Jan 2005 01:51:25 +0000 (GMT) Received: (qmail 2902 invoked from network); 3 Jan 2005 01:54:05 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by localhost with SMTP; 3 Jan 2005 01:54:05 -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 01649-25 for ; Mon, 3 Jan 2005 08:54:04 +0700 (ICT) Received: (qmail 2889 invoked from network); 3 Jan 2005 01:54:04 -0000 Received: from unknown (HELO localhost) (203.157.0.1) by health.moph.go.th with SMTP; 3 Jan 2005 01:54:04 -0000 Received: from 203.157.100.42 ([203.157.100.42]) by webmail.moph.go.th (IMP) with HTTP for ; Mon, 3 Jan 2005 08:54:03 +0700 Message-ID: <1104717243.41d8a5bb9cb9b@webmail.moph.go.th> Date: Mon, 3 Jan 2005 08:54:03 +0700 From: amrit@health2.moph.go.th To: pg@fastcrypt.com 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> <41D827C1.3050707@fastcrypt.com> In-Reply-To: <41D827C1.3050707@fastcrypt.com> 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/6 X-Sequence-Number: 9696 > The common wisdom of shared buffers is around 6-10% of available memory. > Your proposal below is about 50% of memory. > > I'm not sure what the original numbers actually meant, they are quite large. > I will try to reduce shared buffer to 1536 [1.87 Mb]. > also effective cache is the sum of kernel buffers + shared_buffers so it > should be bigger than shared buffers. also make the effective cache to 2097152 [2 Gb]. I will give you the result , because tomorrow [4/12/05] will be the official day of my hospital [which have more than 1700 OPD patient/day]. > Also turning hyperthreading off may help, it is unlikely it is doing any > good unless you are running a relatively new (2.6.x) kernel. Why , could you give me the reason? > I presume you are vacuuming on a regular basis? Yes , vacuumdb daily.