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 08F0F52C19 for ; Fri, 19 Aug 2005 11:03:11 -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 38325-01 for ; Fri, 19 Aug 2005 14:03:09 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id A901A52BE2 for ; Fri, 19 Aug 2005 11:03:08 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j7JE3D3K017940; Fri, 19 Aug 2005 10:03:13 -0400 (EDT) To: "Merlin Moncure" Cc: pgsql-performance@postgresql.org Subject: Re: Finding bottleneck In-reply-to: <6EE64EF3AB31D5448D0007DD34EEB3417DD150@Herge.rcsinc.local> References: <6EE64EF3AB31D5448D0007DD34EEB3417DD150@Herge.rcsinc.local> Comments: In-reply-to "Merlin Moncure" message dated "Fri, 19 Aug 2005 09:37:19 -0400" Date: Fri, 19 Aug 2005 10:03:12 -0400 Message-ID: <17939.1124460192@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200508/261 X-Sequence-Number: 14008 "Merlin Moncure" writes: > Relative to 8.0, I am seeing a dramatic, almost miraculous reduction in > CPU load times in 8.1devel. This is for ISAM style access patterns over > the parse/bind interface. (IOW one record at a time, 90% read, 10% > write). > Relative to commercial dedicated ISAM storage engines, pg holds up very > well except in cpu load, but 8.1 is a huge step towards addressing that. Cool --- we've done a fair amount of work on squeezing out internal inefficiencies during this devel cycle, but it's always hard to predict just how much anyone will notice in the real world. Care to do some oprofile or gprof profiles to see where it's still bad? regards, tom lane