Re: insert performance riddle - Mailing list pgsql-general

From Michael Fuhr
Subject Re: insert performance riddle
Date
Msg-id 20050813002923.GA19294@winnie.fuhr.org
Whole thread Raw
In response to Re: insert performance riddle  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: insert performance riddle  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: insert performance riddle
Next
From: "Ed L."
Date:
Subject: Re: insert performance riddle