Re: Finding bottleneck - Mailing list pgsql-performance

From Tom Lane
Subject Re: Finding bottleneck
Date
Msg-id 17939.1124460192@sss.pgh.pa.us
Whole thread Raw
In response to Re: Finding bottleneck  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List pgsql-performance
"Merlin Moncure" <merlin.moncure@rcsonline.com> 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

pgsql-performance by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: sustained update load of 1-2k/sec
Next
From: Tom Lane
Date:
Subject: Re: sustained update load of 1-2k/sec