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 D875F3A4A4C for ; Thu, 6 Jan 2005 20:22:02 +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 59921-10 for ; Thu, 6 Jan 2005 20:21:37 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 0B3943A4B48 for ; Thu, 6 Jan 2005 20:21:37 +0000 (GMT) Received: from [192.168.1.51] (dsl093-038-087.pdx1.dsl.speakeasy.net [66.93.38.87]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j06KLX60030730; Thu, 6 Jan 2005 12:21:33 -0800 Message-ID: <41DD9DBF.8040501@commandprompt.com> Date: Thu, 06 Jan 2005 12:21:19 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Greg Stark Cc: Frank Wiles , Josh Berkus , pgsql-performance@postgresql.org Subject: Re: Low Performance for big hospital server .. References: <1104831107.41da6283add0c@webmail.moph.go.th> <1104939342.41dc094ecb1cf@webmail.moph.go.th> <758d5e7f050106041510f07dc5@mail.gmail.com> <200501060906.55832.josh@agliodbs.com> <20050106111207.52e39d04.frank@wiles.org> <87mzvmz6et.fsf@stark.xeocode.com> In-Reply-To: <87mzvmz6et.fsf@stark.xeocode.com> Content-Type: multipart/mixed; boundary="------------080102060300080902090002" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.042 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/77 X-Sequence-Number: 9767 This is a multi-part message in MIME format. --------------080102060300080902090002 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Greg Stark wrote: > Frank Wiles writes: > > >> Now that's rich. I don't think I've ever seen a database perform >> worse after it was normalized. In fact, I can't even think of a >> situation where it could! > > > Just remember. All generalisations are false. In general, I would agree. Sincerely, Joshua D. Drake > -- Command Prompt, Inc., home of PostgreSQL Replication, and plPHP. Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL --------------080102060300080902090002 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua D. Drake n:Drake;Joshua D. org:Command Prompt, Inc. adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA email;internet:jd@commandprompt.com title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard --------------080102060300080902090002--