pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Clayton Cottingham aka drfrog <drfrog@smartt.com>
To: pgsql-sql@postgresql.org
Subject: Re: any proper benchmark scripts?
Date: 18 Apr 2001 19:00:24 PDT
Message-ID: <200104190209.f3J29Yj06260@smartt.com> (raw)
In-Reply-To: <3ADC8D97.23D5E339@smartt.com>
References: <3ADC8D97.23D5E339@smartt.com>

hello 

on the modperl list a good thread was happening called 
'fast db access'
find attached scripts used to do this

here are my results:


[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



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




-- 
back in the day
we didn't have no
old school
-dr. frog
http://www.hyperbomb.com
it sells itself

Attachments:

  fast_db.pl (application/x-unknown, 4.7K) download

  benchmark.sql (application/x-unknown, 164B) download

view thread (7+ messages)  latest in thread

Message-ID: <200104190209.f3J29Yj06260@smartt.com>
Permalink:  ../200104190209.f3J29Yj06260@smartt.com/
Also on:    postgresql.org/message-id/200104190209.f3J29Yj06260@smartt.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: drfrog@smartt.com
  Subject: Re: any proper benchmark scripts?
  In-Reply-To: <200104190209.f3J29Yj06260@smartt.com>
  References: <3ADC8D97.23D5E339@smartt.com> <200104190209.f3J29Yj06260@smartt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox