Newest Beta: slover with SELECT then 7.03?

From: Alvar Freude <alvar(dot)freude(at)merz-akademie(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Newest Beta: slover with SELECT then 7.03?
Date: 2000-11-15 06:37:47
Message-ID: 3A122F3B.A3FB8C21@merz-akademie.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Marc Poinot 2000-11-15 12:11:43 Newbie: pg_hba.conf question
Previous Message Kevin Lo 2000-11-15 02:49:38 Re: postgresql on Win 2k??????