Re: insert performance riddle

On Fri, Aug 12, 2005 at 06:20:27PM -0600, Ed L. wrote:
> On Friday August 12 2005 6:11 pm, Michael Fuhr wrote:
> > Has anything changed on the system since the results were
> > consistently slow? New hardware, new versions of anything,
> > reboot, etc.? Did you do any profiling when DBD::Pg was
> > consistently slow to see where the bottleneck was?
>
> All good questions.  Obviously, something has changed, but I'm
> hard-pressed to identify what it might have been.  No, I didn't
> do any profiling, since I found the presumed dbi/libpq
> difference first.  I will measure perf of dbi, Pg, and libpq
> over time and see if I can combine with I/O measures to see
> trends.

I meant profiling of DBD::Pg, as Greg Sabino Mullane suggested.
Here's his message in case you missed it:

http://archives.postgresql.org/pgsql-general/2005-08/msg00655.php

--
Michael Fuhr