X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 61DDDDA101 for ; Wed, 5 Oct 2005 00:07:04 -0300 (ADT) 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 83964-05 for ; Wed, 5 Oct 2005 03:07:02 +0000 (GMT) Received: from pop-cowbird.atl.sa.earthlink.net (pop-cowbird.atl.sa.earthlink.net [207.69.195.68]) by svr1.postgresql.org (Postfix) with ESMTP id 6453DDA0F9 for ; Wed, 5 Oct 2005 00:07:01 -0300 (ADT) Received: from elwamui-polski.atl.sa.earthlink.net ([209.86.224.45]) by pop-cowbird.atl.sa.earthlink.net with esmtp (Exim 3.36 #10) id 1EMzcM-0004F8-00; Tue, 04 Oct 2005 23:06:54 -0400 Message-ID: <17434238.1128481614269.JavaMail.root@elwamui-polski.atl.sa.earthlink.net> Date: Tue, 4 Oct 2005 23:06:54 -0400 (EDT) From: Ron Peacetree Reply-To: Ron Peacetree To: "Joshua D. Drake" , pgsql-performance@postgresql.org Subject: Re: Is There Any Way .... Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: EarthLink Zoo Mail 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.257 required=5 tests=[AWL=-0.117, DNS_FROM_RFC_ABUSE=0.374] X-Spam-Level: X-Archive-Number: 200510/65 X-Sequence-Number: 14833 Unfortunately, no matter what I say or do, I'm not going to please or convince anyone who has already have made their minds up to the extent that they post comments like Mr Trainor's below. His response style pretty much proves my earlier point that this is presently a religious issue within the pg community. The absolute best proof would be to build a version of pg that does what Oracle and DB2 have done and implement it's own DB specific memory manager and then compare the performance between the two versions on the same HW, OS, and schema. The second best proof would be to set up either DB2 or Oracle so that they _don't_ use their memory managers and compare their performance to a set up that _does_ use said memory managers on the same HW, OS, and schema. I don't currently have the resources for either experiment. Some might even argue that IBM (where Codd and Date worked) and Oracle just _might_ have had justification for the huge effort they put into developing such infrastructure. Then there's the large library of research on caching strategies in just about every HW and SW domain, including DB theory, that points put that the more context dependent, ie application or domain specific awareness, caching strategies are the better they are. Maybe after we do all we can about physical IO and sorting performance I'll take on the religious fanatics on this one. One problem set at a time. Ron -----Original Message----- From: "Joshua D. Drake" Sent: Oct 4, 2005 9:32 PM To: "Douglas J. Trainor" Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Is There Any Way .... Douglas J. Trainor wrote: > > Ron Peacetree sounds like someone talking out of his _AZZ_. > He can save his unreferenced flapdoodle for his SQL Server > clients. Maybe he will post references so that we may all > learn at the feet of Master Peacetree. :-) Although I agree that I would definitely like to see some test cases for what Ron is talking about, I don't think that resorting to insults is going to help the situation. Ron, if you would please -- provide some test cases for what you are describing I am sure that anyone would love to see them. We are all for improving PostgreSQL. Sincerely, Joshua D. Drake -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend