Re: insert performance riddle

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: insert performance riddle
Date: 2005-08-12 23:37:22
Message-ID: 200508121737.22251.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday August 12 2005 5:27 pm, Michael Fuhr wrote:
> On Fri, Aug 12, 2005 at 05:20:49PM -0600, Ed L. wrote:
> > Well, just as I thought I had this one pinned, my test
> > results have become wildly inconsistent, eroding all
> > confidence in my prior conclusions about DBI slowness, etc.
> > I've seen at least 1000+ QPS performance via DBI/DBD::Pg,
> > Pg, and C/libpq. I'm now investigating the possibility of
> > simple old intermittent I/O congestion...
>
> 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. :/

Ed

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-08-13 00:11:47 Re: insert performance riddle
Previous Message Michael Fuhr 2005-08-12 23:27:12 Re: insert performance riddle