Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id DF7949FA4B6 for ; Sun, 7 Jan 2007 00:56:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 48220-05 for ; Sun, 7 Jan 2007 00:56:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (unknown [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 2B1489F9FB2 for ; Sun, 7 Jan 2007 00:56:40 -0400 (AST) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l074ugvo027231 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Sat, 6 Jan 2007 20:56:43 -0800 Subject: Re: High update activity, PostgreSQL vs BigDBMS From: "Joshua D. Drake" To: Guy Rouillier Cc: PostgreSQL Performance In-Reply-To: <45A077FB.3010802@burntmail.com> References: <45935A49.6080602@burntmail.com> <459F0EA6.30403@burntmail.com> <45A077FB.3010802@burntmail.com> Content-Type: text/plain Organization: Command Prompt, Inc. Date: Sat, 06 Jan 2007 20:56:47 -0800 Message-Id: <1168145807.869.22.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Sat, 06 Jan 2007 20:56:43 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/83 X-Sequence-Number: 22684 > Regarding shared_buffers=750MB, the last discussions I remember on this > subject said that anything over 10,000 (8K buffers = 80 MB) had unproven > benefits. So I'm surprised to see such a large value suggested. I'll > certainly give it a try and see what happens. > That is old news :) As of 8.1 it is quite beneficial to go well above the aforementioned amount. J > >> > >> autovacuum=on > >> stats_row_level = on > >> max_connections = 10 > >> listen_addresses = 'db01,localhost' > >> shared_buffers = 128MB > >> work_mem = 16MB > >> maintenance_work_mem = 64MB > >> temp_buffers = 32MB > >> max_fsm_pages = 204800 > >> checkpoint_segments = 30 > >> redirect_stderr = on > >> log_line_prefix = '%t %d' -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate