X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 77E79D1C92F for ; Mon, 4 Aug 2003 16:37:50 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 26065-10 for ; Mon, 4 Aug 2003 13:36:33 -0300 (ADT) Received: from smtp.pspl.co.in (unknown [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 8AA19D1C914 for ; Mon, 4 Aug 2003 13:37:38 -0300 (ADT) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id h74Gbc1f000483 for ; Mon, 4 Aug 2003 22:07:38 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id h74GbbK7000456; Mon, 4 Aug 2003 22:07:37 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org, pgsql-general@postgresql.org, osdldbt-general@lists.sourceforge.net Date: Mon, 04 Aug 2003 22:09:27 +0530 MIME-Version: 1.0 Subject: Re: [PERFORM] OSDL Database Test Suite 3 is available on PostgreSQL Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3F2ED997.25642.6C9A5E@localhost> In-reply-to: References: <1059761051.1535.396.camel@ibm-a> X-mailer: Pegasus Mail for Windows (v4.12a) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/162 X-Sequence-Number: 46579 On 4 Aug 2003 at 15:33, Manfred Koizar wrote: > On 01 Aug 2003 11:04:10 -0700, Jenny Zhang wrote: > >A sample OSDL-DBT3 test result report can be found at: > >http://khack.osdl.org/stp/276912/ > > > >Your comments are welcome, I could not get postgresql .conf so I will combine the comments. 1. Effective cache size, already mentioned 2. Sort memory already mentioned. 3. Was WAL put on different drive? 4. Can you try with autovacuum daemon and 7.4beta when it comes out.. 5. What was the file system? Ext2/Ext3/reiser/XFS? Is there any comparison available for other databases.. Could be interesting to see..:-) Thanks for the good work. I understand it must have been quite an effort to run it.. Keep it up.. Bye Shridhar -- Fourth Law of Revision: It is usually impractical to worry beforehand about interferences -- if you have none, someone will make one for you.