X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 1D4F3B43A4B for ; Mon, 7 Jul 2003 21:31:19 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 27833-05 for ; Mon, 7 Jul 2003 18:31:00 -0300 (ADT) Received: from www.postgresql.com (www.postgresql.com [64.117.225.209]) by svr1.postgresql.org (Postfix) with ESMTP id 2181EB4316B for ; Mon, 7 Jul 2003 18:31:00 -0300 (ADT) Received: from mail.travelamericas.com (dsl231-059-037.sea1.dsl.speakeasy.net [216.231.59.37]) by www.postgresql.com (Postfix) with SMTP id 0473ECF6E47 for ; Mon, 7 Jul 2003 14:09:51 -0300 (ADT) Received: (qmail 25067 invoked from network); 7 Jul 2003 17:08:50 -0000 Received: from unknown (HELO travelamericas.com) (127.0.0.1) by localhost with SMTP; 7 Jul 2003 17:08:50 -0000 Message-ID: <3F09A922.2050409@travelamericas.com> Date: Mon, 07 Jul 2003 10:08:50 -0700 From: Chris Travers User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Matthew Nuzum Cc: pgsql-performance@postgresql.org Subject: Re: Moving postgresql.conf tunables into 2003... References: <006901c34430$1da72c80$a322fea9@mattspc> In-Reply-To: <006901c34430$1da72c80$a322fea9@mattspc> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/136 X-Sequence-Number: 2429 Matthew Nuzum wrote: >>I'm highly resistant to/disappointed in this attitude and firmly >>believe that there are well understood algorithms that DBAs use to >>diagnose and solve performance problems. It's only a black art >>because it hasn't been documented. Performance tuning isn't voodoo, >>it's adjusting constraints to align with the execution of applications >>and we know what the applications do, therefore the database can mold >>to the applications' needs. >> >> > >I agree. > >We often seem to forget simple lessons in human nature. Expecting someone >to spend 20 extra seconds to do something is often too much. In many cases, >the only "manual" that a person will see is the .conf files. > > > In my opinion, a serious RDBMS system will *always* require the admin to be doing research in order to learn how to use it effectively. We are not talking about a word processor here. That being said, I think that a good part of the problem is that admins don't know where to look for the appropriate documentation and what is needed. Expecting someone to spend 20 seconds looking for a piece of info is not too bad, but expecting them to spend hours trying to figure out what info is relavent is not going to get us anywhere. For those who have been following the discussion relating to MySQL vs PostgreSQL, I think this is relavent here. MySQL does much of its tuning at compile time, and the MySQL team very carefully controls the build process for the various binary distriutions they offer. If you want to see a real mess, try compiling MySQL from source. Talk about having to read documentation on items which *should* be handled by the configure script. OTOH, PostgreSQL is optomized using configuration files and is tunable on the fly. This is, I think, a better approach but it needs to be better documented. Maybe a "Beginner's guide to database server tuning" or something like that. Secondly, documenting the tuning algorythms well my allow PostgreSQL to automatically tune itself to some extent or for the development of performance tuning tools for the server. This would be a big win for the project. Unfortunately I am not knowledgable on this topic to really do this subject justice. Best Wishes, Chris Travers