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 28E14B43848 for ; Mon, 7 Jul 2003 13:23:51 +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 71554-02 for ; Mon, 7 Jul 2003 10:23:39 -0300 (ADT) Received: from mwinf0402.wanadoo.fr (smtp5.wanadoo.fr [193.252.22.27]) by svr1.postgresql.org (Postfix) with ESMTP id C0D38B438AC for ; Mon, 7 Jul 2003 10:23:35 -0300 (ADT) Received: from Paris (ABoulogne-110-1-3-50.w80-15.abo.wanadoo.fr [80.15.41.50]) by mwinf0402.wanadoo.fr (SMTP Server) with ESMTP id 5982B8000B4 for ; Mon, 7 Jul 2003 15:23:38 +0200 (CEST) Reply-To: From: "Michael Mattox" To: Subject: Re: Moving postgresql.conf tunables into 2003... Date: Mon, 7 Jul 2003 15:23:40 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <008301c34489$4dbf0b00$a322fea9@mattspc> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/127 X-Sequence-Number: 2420 > Are you willing to say that the PostgreSQL database system should only be > used by DBAs? I believe that Postgres is such a good and useful tool that > anyone should be able to start using it with little or no barrier > to entry. This is a good point. After reading previous responses I was starting to feel like the only non-DBA Postgres user on this list. I'm a java architect/developer and until recently I knew very little about databases. I just learned what an index was while trying to tune Postgres. I imagine some of you are even laughing reading this but it's true. In Java land, the O/R mapping tools are getting so good that you don't have to be a database expert to use the database. I'm using JDO which generates my database tables and indexes automatically. But you do need to learn about the database in order to increase performance and optimize the settings. I'm sure I'm not the only developer who is overwhelmed by the Postgres documentation and configuration files. Regards, Michael