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 827E38B9D70 for ; Wed, 2 Feb 2005 21:23:05 +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 44606-08 for ; Wed, 2 Feb 2005 21:22:54 +0000 (GMT) Received: from smtp0.libero.it (smtp0.libero.it [193.70.192.33]) by svr1.postgresql.org (Postfix) with ESMTP id B0A9C8B9BCC for ; Wed, 2 Feb 2005 21:22:54 +0000 (GMT) Received: from localhost (172.16.1.83) by smtp0.libero.it (7.0.027-DD01) id 41BDA86900ADFFF8; Wed, 2 Feb 2005 22:22:52 +0100 Received: from [62.98.83.93] (62.98.83.93) by smtp2.libero.it (7.0.027-DD01) (authenticated as tdezotti@inwind.it) id 41BF65E4038E00F9; Wed, 2 Feb 2005 22:10:29 +0100 Message-ID: <420141A8.2090800@streppone.it> Date: Wed, 02 Feb 2005 22:10:00 +0100 From: Cosimo Streppone User-Agent: Mozilla Thunderbird 0.9 (X11/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Merlin Moncure Cc: Postgresql Performance list Subject: Re: High end server and storage for a PostgreSQL OLTP system References: <6EE64EF3AB31D5448D0007DD34EEB3412A7603@Herge.rcsinc.local> In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3412A7603@Herge.rcsinc.local> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at libero.it serv4 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.916 tagged_above=0 required=5 tests=AWL, RCVD_IN_BL_SPAMCOP_NET X-Spam-Level: X-Archive-Number: 200502/40 X-Sequence-Number: 10369 Merlin Moncure wrote: > > [...] > > (...DBI + DBD::Pg), so that switching to 8.0 should > > automatically enable the "single-prepare, multiple-execute" behavior, > > saving a lot of query planner processing, if I understand correctly. > > [...] > > I know that the perl people were pushing for certain features into the > libpq library (describing prepared statements, IIRC). I think this > stuff made it into 8.0...have no clue about DBD::pg. For the record: yes, DBD::Pg in CVS (> 1.32) has support for server prepared statements. > If everything is working the way it's supposed to, 8.0 should be faster > than 7.1 (like, twice faster) for what you are probably trying to do. In the next days I will be testing the entire application with the same database only changing the backend from 7.1 to 8.0, so this is a somewhat perfect condition to have a "real-world" benchmark of Pg 8.0 vs 7.1.x performances. -- Cosimo