Received: from marketingchallenge.com (marketingchallenge.com [64.40.111.205] (may be forged)) by postgresql.org (8.11.3/8.11.1) with SMTP id f3JG3wu80365 for ; Thu, 19 Apr 2001 12:03:58 -0400 (EDT) (envelope-from drfrog@smartt.com) Received: (qmail 24408 invoked from network); 19 Apr 2001 16:03:57 -0000 Received: from clayton-cottingham.imc (HELO smartt.com) (drfrog@10.1.4.1) by marketingchallenge.com with SMTP; 19 Apr 2001 16:03:57 -0000 Message-ID: <3ADF0C72.7F2CA67C@smartt.com> Date: Thu, 19 Apr 2001 09:04:02 -0700 From: clayton cottingham X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: Thomas Good CC: pgsql-sql@postgresql.org Subject: Re: any proper benchmark scripts? References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200104/332 X-Sequence-Number: 2689 Thomas Good wrote: > > On 18 Apr 2001, Clayton Cottingham aka drfrog wrote: > > > i will recomp both the newest postgresql and mysql > > not using any optimizing techs at all i'll post the > > config scripts i use > > Hiya Clayton, > > Try it with a few hundred thousand tuples in a good size table with > say 300 users banging on the box. MySQL is a nice substitute for > Access but that's about it. > if you check the script youll see its fairly cool how they set it up > Not to mention missing features: views and foreign keys for > example...and have a look at the API...yuck. I always hear people > complain (MySQL fans) about Pg not having DROP COLUMN in its SQL > implementation. To me a VIEW is slightly more important. ;-) > yes all that was tested was inserts and selects check my prev post if you check out that thread on modperl youlll see why these where not included they were testing hashes versus Storable.pm versus postgres versus flatfile > (Trying hard not to be obnoxious here but failing. Comparing MySQL > to Pg is like comparing windows to BSD...and I just can't apologise > for calling it like I see it!) i agree > > Cheers! > Tom (the most obnoxious man in Staten Island?) >