Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 188D664FCE3 for ; Fri, 5 Sep 2008 09:38:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 83836-04 for ; Fri, 5 Sep 2008 09:37:56 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.152]) by postgresql.org (Postfix) with ESMTP id 6B08964FCDD for ; Fri, 5 Sep 2008 09:37:55 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 16so777532fgg.23 for ; Fri, 05 Sep 2008 05:37:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=c/t6UlFxQnQelbxcsOvK0dUTxUquRlzkUb8XqdPjsmA=; b=SXrIRdUQj0WHibOskGqRIKzS+aN8n5owKCzLsvN640dSCyzCxewWnEFCeoPaCpajw/ 9jsyON1DLtXGJaDOqYrhzf9p6yhUrT05s/fqT8Q4jhKY16UqJJ3m0q+duLFMnh/sAKNW QVttDS/s2S6C9M8tJWtRb2eSt7Z94Coxl9LVk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=LicGMHPwfweeQT3NEfsnyf6rWAkOeW5jay3KE0H184zB2ppXE8TsYapgrBPXtEeuun peD0gKOCYK8qRfsXdXAq8OwgZABJqjXKVb2yLQNJTisCvbGOveX/aHMAbwbIjyDuSjuy H+TbuVuP2xoxh65sVweryDyP7lDVPWy5LyZjk= Received: by 10.86.57.9 with SMTP id f9mr8726545fga.66.1220618273574; Fri, 05 Sep 2008 05:37:53 -0700 (PDT) Received: by 10.86.79.10 with HTTP; Fri, 5 Sep 2008 05:37:53 -0700 (PDT) Message-ID: Date: Fri, 5 Sep 2008 14:37:53 +0200 From: "Claus Guttesen" To: "Jonas Pacheco" Subject: Re: You may need to increase mas_loks_per_trasaction Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/72 X-Sequence-Number: 31385 > Considering a quad core server processor, 4 GBs of RAM memory, disk Sata > 2. > > What is the recommended setting for the parameters: > > max_connections:70 Depends on how many clients that access the database. > shared_buffers? I have mine at 512 MB but I will lower it and see how it affects performance. I have 16 GB in my server. > max_fsm_relations? > max_fsm_pages? Perform a vacuum analyze verbose and look at the last few lines. This will tell you whether you need to increase max_fsm_*. Consider lowering random_page_cost so it favoes indexex more often than seq. scans. But if you don't get a decent raid-controller your data will move slow and tuning will only make a minor difference. -- regards Claus When lenity and cruelty play for a kingdom, the gentler gamester is the soonest winner. Shakespeare