X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D2CD49F9F8F for ; Tue, 16 May 2006 07:05:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 33054-03 for ; Tue, 16 May 2006 07:05:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 517E39F9C18 for ; Tue, 16 May 2006 07:05:12 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id D257131923; Tue, 16 May 2006 12:05:10 +0200 (MET DST) From: "Qingqing Zhou" X-Newsgroups: pgsql.performance Subject: Re: Pgsql (and mysql) benchmark on T2000/Solaris and some profiling Date: Tue, 16 May 2006 18:01:26 +0800 Organization: Hub.Org Networking Services Lines: 30 Message-ID: References: <44699C6C.80302@tweakers.net> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1807 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1807 To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/342 X-Sequence-Number: 19129 "Arjen van der Meijden" wrote > > Long story short, we think the test is a nice example of the relatively > lightweight, read-heavy webapplications out there and therefore decided > to have a go at postgresql as well. > Some sort of web query behavior is quite optimized in MySQL. For example, the query below is runing very fast due to the query result cache implementation in MySQL. Loop N times SELECT * FROM A WHERE i = 1; End loop. > You can find the samples here: > http://achelois.tweakers.net/~acm/pgsql-t2000/syscall.log > http://achelois.tweakers.net/~acm/pgsql-t2000/usrcall.log > IMHO, without knowing the exact queries you sent, these logs are not very useful :-(. I would suggest you compare the queries in pair and then post their dtrace/timing results here (just like the previous Firebird vs. PostgreSQL comparison did). Regards, Qingqing