Re: insert performance riddle

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: insert performance riddle
Date: 2005-08-13 00:29:23
Message-ID: 20050813002923.GA19294@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2005-08-13 00:45:44 Re: insert performance riddle
Previous Message Ed L. 2005-08-13 00:20:27 Re: insert performance riddle