[drfrog]$ perl fast_db.pl
postgres
16 wallclock secs ( 0.05 usr + 0.00 sys = 0.05 CPU) @ 400.00/s (n=20)
mysql
3 wallclock secs ( 0.07 usr + 0.00 sys = 0.07 CPU) @ 285.71/s (n=20)
postgres
17 wallclock secs ( 0.06 usr + 0.00 sys = 0.06 CPU) @ 333.33/s (n=20)
mysql
3 wallclock secs ( 0.01 usr + 0.01 sys = 0.02 CPU) @ 1000.00/s (n=20)
correct me if im wrong but if fast_db.pl is
working right
first set is insert
second set is select
find attached the modified ver of fast_db.pl
i sued to conduct this test
comp stats
running stock rpms from mandrake 7.2 for both
postgresql and mysql
3.23.23-beta of mysql and
7.02 of postgresql
[drfrog@nomad desktop]$ uname -a
Linux nomad.localdomain 2.2.18 #2 Tue Apr 17 22:55:04 PDT 2001 i686 unknown
[drfrog]$ cat /proc/meminfo
total: used: free: shared: buffers: cached:
Mem: 257511424 170409984 87101440 24219648 96067584 44507136
Swap: 254943232 0 254943232
MemTotal: 251476 kB
MemFree: 85060 kB
MemShared: 23652 kB
Buffers: 93816 kB
Cached: 43464 kB
SwapTotal: 248968 kB
SwapFree: 248968 kB
[drfrog]$ cat /proc/cpuinfo
processor : 0
vendor_id : AuthenticAMD
cpu family : 6
model : 3
model name : AMD Duron(tm) Processor
stepping : 1
cpu MHz : 697.535
cache size : 64 KB
fdiv_bug : no
hlt_bug : no
sep_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 sep mtrr pge mca cmov pat
pse36 psn mmxext mmx fxsr 3dnowext 3dnow
bogomips : 1392.64
i will recomp both the newest postgresql and mysql
not using any optimizing techs at all i'll post the
config scripts i use
On Tue, 17 Apr 2001 18:24:43 -0700, clayton said:
> Matt Sergeant wrote:
>
> > On Tue, 17 Apr 2001, Differentiated Software Solutions Pvt. Ltd., wrote:
> >
> >> H/W : Celeron 433 with 64 MB RAM, IDE HDD using RH 6.1, perl 5.005,
> >> Postgres 6.5.3
> >
> >
> > This is a very very old version of postgresql. Try it again with 7.1 for
> > more respectable results.
> >
>
>
> im very glad to see this thread
>
> i wanted a good benchmark for postgres and mysql
> {i hope to transpose the sql properly!}
>
> i do have 7.1 installed and it is very sweet
>
> ill report back when i rerun under postgresql at the very least
>
>
>
>
--
back in the day
we didn't have no
old school
-dr. frog
http://www.hyperbomb.com
it sells itself
fast_db.pl