X-Original-To: pgsql-general@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4A20F475A5C for ; Thu, 30 Jan 2003 17:24:56 -0500 (EST) Received: from mail.com-stock.com (mail.com-stock.com [204.255.137.254]) by postgresql.org (Postfix) with ESMTP id E98074762AF for ; Thu, 30 Jan 2003 14:42:01 -0500 (EST) Received: by mail.com-stock.com (Postfix, from userid 1000) id B896B110; Thu, 30 Jan 2003 14:42:01 -0500 (EST) Received: from deimos (deimos.com-stock.com [204.255.137.120]) by mail.com-stock.com (Postfix) with SMTP id 7122ADA0B; Thu, 30 Jan 2003 14:41:59 -0500 (EST) Message-ID: <016b01c2c898$891d05c0$7889ffcc@comstock.com> From: "Gregory Wood" To: "Jeff" Cc: "PostgreSQL-General" References: Subject: Re: [PERFORM] One large v. many small Date: Thu, 30 Jan 2003 14:48:16 -0500 Organization: Comstock Net Services MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/1535 X-Sequence-Number: 36656 > imagine this scenario using your > methods (with a wonderful pg performance problem in hand (unless you are > running cvs)) > If you do a little app tuning (maybe spend 10-30 minutes readig pgsql > archives) you'll learn to rewrite it as an exists query and make it faster > than it ever could have been on the fast hardware. Your example is invalid... you're talking about an implementation detail, not an architectural design issue. I have to agree with the original point... normalize the database into the proper form, then denormalize as necessary to make things perform acceptably. In other words, do things the right way and then muck it up if you have to. While you make an excellent point (i.e. you can't always through hardware, especially excessive hardware at the problem), I would err on the side of doing things the right way. It usually ends up making the software easier to maintain and add to. A poor design to save a few thousand dollars on hardware now can cost many tens of thousands (or more) dollars on programming time down the road. I've seen entirely too many cases where people started thinking about performance before they considered overall design. It almost always ends in disaster (especially since hardware only gets faster over time and software only gets more complex). Greg