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
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 ;)
Alvar C.H. Freude | alvar(dot)freude(at)merz-akademie(dot)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-admin by date
|Next:||From: Marc Poinot||Date: 2000-11-15 12:11:43|
|Subject: Newbie: pg_hba.conf question|
|Previous:||From: Kevin Lo||Date: 2000-11-15 02:49:38|
|Subject: Re: postgresql on Win 2k??????|