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 7153F3A18CF for ; Thu, 20 Jan 2005 15:42:42 +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 16807-07 for ; Thu, 20 Jan 2005 15:42:23 +0000 (GMT) Received: from webmail.moph.go.th (health.moph.go.th [203.157.0.1]) by svr1.postgresql.org (Postfix) with SMTP id 43C2C3A45AA for ; Thu, 20 Jan 2005 15:42:25 +0000 (GMT) Received: (qmail 29166 invoked from network); 20 Jan 2005 15:45:07 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by localhost with SMTP; 20 Jan 2005 15:45:07 -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 27995-34 for ; Thu, 20 Jan 2005 22:45:05 +0700 (ICT) Received: (qmail 29158 invoked from network); 20 Jan 2005 15:45:05 -0000 Received: from unknown (HELO localhost) (203.157.0.1) by health.moph.go.th with SMTP; 20 Jan 2005 15:45:05 -0000 Received: from 203.157.100.42 ([203.157.100.42]) by webmail.moph.go.th (IMP) with HTTP for ; Thu, 20 Jan 2005 22:45:05 +0700 Message-ID: <1106235905.41efd201295a5@webmail.moph.go.th> Date: Thu, 20 Jan 2005 22:45:05 +0700 From: amrit@health2.moph.go.th To: PGsql-performance Subject: Which PARAMETER is most important for load query?? 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/304 X-Sequence-Number: 9994 I'm dealing with big database [3.8 Gb] and records of 3 millions . Some of the query seems to be slow eventhough just a few users in the night. I would like to know which parameter list below is most effective in rising the speed of these queries? Shmmax = 32384*8192 =265289728 Share buffer = 32384 sort_mem = 34025 <===== I guess increase this one is most effective but too high cause reading the swap , is that right? effective cache = 153204 My server has 4 Gb. ram and ~ 140 clients in rush hours. Amrit Thailand