Re: Is Oracle really so much faster - Mailing list pgsql-general

From Alvar Freude
Subject Re: Is Oracle really so much faster
Date
Msg-id 3A79E876.71CA93D2@merz-akademie.de
Whole thread Raw
In response to RE: Is Oracle really so much faster  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-general
Hi,

> > try to make the commit every 500 or 1000 inserts. It seems to me, that
> > PG slow down if there are lots of MBs waiting for commit ...
>
> MB == Memory Buffers?
> If so then it shouldn't be the case for 7.0.X with Tom' work in bufmgr area.

Megabytes :-)

tested in 7.1


The inserts slow down if there are too much not-committed inserts
pending. But, I'm only sure about the time for the insert statement
itself, and not the complete time -- perhaps a final commit is faster
then the sum of a lot of commits in between.

At my test, I used two insert per object, and each object needed about
35 milliseconds (on P2/350 MHz) at each table size. If i inserted ~15000
obejcts in one transaction, the insertion time for each request slows
down to ~200 milliseconds at the end.


So, I guess this has to be tested in detail again ;)


Ciao
  Alvar

--
Alvar C.H. Freude  |  alvar.freude@merz-akademie.de

    Demo: http://www.online-demonstration.org/  |  Mach mit!
Blast-DE: http://www.assoziations-blaster.de/   |  Blast-Dich-Fit
Blast-EN: http://www.a-blast.org/               |  Blast/english

pgsql-general by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: Is Oracle really so much faster
Next
From: Alfonso Peniche
Date:
Subject: sintax???