X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D76249FB3C3 for ; Thu, 21 Sep 2006 12:13:48 -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 12704-01-9 for ; Thu, 21 Sep 2006 12:13:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 63BDC9FB3F4 for ; Thu, 21 Sep 2006 12:12:45 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k8LFCj4w000830; Thu, 21 Sep 2006 11:12:45 -0400 (EDT) To: yoav x cc: pgsql-performance@postgresql.org Subject: Re: PostgreSQL and sql-bench In-reply-to: <20060921145244.13005.qmail@web35813.mail.mud.yahoo.com> References: <20060921145244.13005.qmail@web35813.mail.mud.yahoo.com> Comments: In-reply-to yoav x message dated "Thu, 21 Sep 2006 07:52:44 -0700" Date: Thu, 21 Sep 2006 11:12:45 -0400 Message-ID: <829.1158851565@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.1 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200609/281 X-Sequence-Number: 20967 yoav x writes: > I've applied the following parameters to postgres.conf: > max_connections = 500 > shared_buffers = 3000 > work_mem = 100000 > effective_cache_size = 3000000000 Please see my earlier reply --- you ignored at least checkpoint_segments, which is critical, and perhaps other things. Don't forget also that testing mysql/myisam against fsync = on is inherently unfair. regards, tom lane