Received: from mail2.panix.com (mail2.panix.com [166.84.0.213]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3JCTWu87756 for ; Thu, 19 Apr 2001 08:29:32 -0400 (EDT) (envelope-from tomg@admin.nrnet.org) Received: from mailhost.nrnet.org (mailhost.nrnet.org [166.84.192.39]) by mail2.panix.com (Postfix) with ESMTP id 7BE619657; Thu, 19 Apr 2001 08:20:34 -0400 (EDT) Received: from admin.nrnet.org (uucp@localhost) by mailhost.nrnet.org (8.9.3/8.9.3) with UUCP id IAA28949; Thu, 19 Apr 2001 08:21:34 -0400 Received: from localhost (tomg@localhost) by admin.nrnet.org (8.9.1/8.9.1) with ESMTP id IAA00448; Thu, 19 Apr 2001 08:24:06 -0400 Date: Thu, 19 Apr 2001 08:24:06 -0400 (EDT) From: Thomas Good To: Clayton Cottingham aka drfrog Cc: pgsql-sql@postgresql.org Subject: Re: any proper benchmark scripts? In-Reply-To: <200104190209.f3J29Yj06260@smartt.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200104/325 X-Sequence-Number: 2681 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. 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. ;-) (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!) Cheers! Tom (the most obnoxious man in Staten Island?) -------------------------------------------------------------------- SVCMC - Center for Behavioral Health -------------------------------------------------------------------- Thomas Good tomg@ { admin | q8 } .nrnet.org Database Administrator Phone: 718-354-5528 Staten Island Region Mobile: 917-282-7359 -------------------------------------------------------------------- Powered by: PostgreSQL s l a c k w a r e FreeBSD: RDBMS |---------- linux The Power To Serve -------------------------------------------------------------------- /* We prefer linguistic vigor over mathematical rigor. */