Hello list,
I installed and compiled the latest CVS-Beta of Postgres and made some
simple benchmarks with extremely simple tables (only a SERIAL and a int4
column).
According to http://www.phpbuilder.com/columns/tim20001112.php3 the
newest beta is much more faster then the 7.0 releases.
But with my tests the 7.0 needs ~1.6 milliseconds for each
SELECT number FROM simple WHERE id = 123
where 123 is always different a random number.
I compiled Postgres without any options and started postmaster with the
-F option, so inserts are much more faster then in 7.0 without -F, but
always ~10 times slower then the same with MySQL (on the other hand: the
select statement needs on mysql about 1.1 milliseconds, so the
differences are here not so big).
I guess there are some configuration options which helps to speed up the
stuff, any hints?
Also with some other other simple speed benchmarks i found some strange
behaviour, if some of the developers is interested let me know; the next
days I'll make some more complicated ;)
Bye
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