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 675605652E for ; Tue, 15 Mar 2005 13:31:41 +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 37237-06 for ; Tue, 15 Mar 2005 13:31:34 +0000 (GMT) Received: from rwcrmhc12.comcast.net (rwcrmhc12.comcast.net [216.148.227.85]) by svr1.postgresql.org (Postfix) with ESMTP id D157E564A2 for ; Tue, 15 Mar 2005 13:31:32 +0000 (GMT) Received: from [192.168.11.5] (c-24-118-153-224.mn.client2.attbi.com[24.118.153.224]) by comcast.net (rwcrmhc12) with SMTP id <2005031513313501400js0que>; Tue, 15 Mar 2005 13:31:35 +0000 In-Reply-To: References: Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <8dd8c52718f9c9153fe089d64a496150@propertykey.com> Content-Transfer-Encoding: 7bit Cc: pgsql-performance@postgresql.org From: Jeff Hoffmann Subject: Re: Changing the random_page_cost default (was: cpu_tuple_cost) Date: Tue, 15 Mar 2005 07:31:19 -0600 To: "Greg Sabino Mullane" X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/298 X-Sequence-Number: 11003 On Mar 15, 2005, at 6:35 AM, Greg Sabino Mullane wrote: > Granted, I don't work on > any huge, complex, hundreds of gig databases, but that supports my > point - > if you are really better off with a /higher/ (than 3) > random_page_cost, you > already should be tweaking a lot of stuff yourself anyway. I think this is a good point. The people that tend to benefit from the lower cost are precisely the people least likely to know to change it. It's the "install & go" crowd with smaller databases and only a few users/low concurrency that expect it to "just work". The bigger installations are more like to have dedicated DB admins that understand tuning. Wasn't there an idea on the table once to ship with several different configuration files with different defaults for small, medium, large, etc. installs? Wouldn't it make sense to ask the user during initdb to pick from one of the default config files? Or even have a few simple questions like "How much memory do you expect to be available to PostgreSQL?" and "How many concurrent users do you expect to have?". It's one thing to know how much memory is in a machine, it quite another thing to know how much the user wants dedicated to PostgreSQL. A couple of questions like that can go a long way to coming up with better ballpark figures. -- Jeff Hoffmann jeff@propertykey.com