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:11:47
Message-ID: 20050813001147.GA19223@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 12, 2005 at 05:37:22PM -0600, Ed L. wrote:
> On Friday August 12 2005 5:27 pm, Michael Fuhr wrote:
> > How consistent were the results before? I got the impression
> > that you saw consistently bad performance with DBD::Pg when
> > other methods performed well.
>
> Results were very consistent until this morning. Now dbi/dbd::pg
> are intermittently showing performance 1-2 orders of magnitude
> faster. :/

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?

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Giovanni M. 2005-08-13 00:13:31 Upgrading 8.0.2 to 8.0.3 on Windows XP
Previous Message Ed L. 2005-08-12 23:37:22 Re: insert performance riddle