Re: insert performance riddle

Поиск
Список
Период
Сортировка
От Ed L.
Тема Re: insert performance riddle
Дата
Msg-id 200508121720.49799.pgsql@bluepolka.net
обсуждение исходный текст
Ответ на Re: insert performance riddle  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: insert performance riddle  (Michael Fuhr <mike@fuhr.org>)
Список pgsql-general
On Thursday August 11 2005 6:20 pm, Michael Fuhr wrote:
> On Thu, Aug 11, 2005 at 03:29:29PM -0600, Ed L. wrote:
> > Michael, you nailed it again.  My libpq test C program
> > delivered between 2400 QPS and 5000 QPS vs ~10 QPS for
> > DBI/DBD::Pg on this box.
> >
> > It remains unclear to me why the same DBI/DBD::Pg client
> > code would deliver performance 2-3 orders of magnitude
> > better on other roughly comparable or inferior boxes.
>
> I'd suggest contacting the module's maintainer -- see the
> AUTHORS section of the DBD::Pg manual page for contact info.

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...

Ed


В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Travers
Дата:
Сообщение: Re: Seeking PL/PGSQL example
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: insert performance riddle