X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CCA6352936 for ; Fri, 29 Jul 2005 14:13:54 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 92264-06 for ; Fri, 29 Jul 2005 17:13:52 +0000 (GMT) Received: from mail.Mi8.com (d01gw01.mi8.com [63.240.6.47]) by svr1.postgresql.org (Postfix) with ESMTP id 2C23A5282C for ; Fri, 29 Jul 2005 14:13:51 -0300 (ADT) Received: from 172.16.1.112 by mail.Mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D1)); Fri, 29 Jul 2005 13:13:41 -0400 X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01SMTP02.Mi8.com with Microsoft SMTPSVC(6.0.3790.211); Fri, 29 Jul 2005 13:13:41 -0400 Received: from 67.103.45.218 ([67.103.45.218]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.104]) with Microsoft Exchange Server HTTP-DAV ; Fri, 29 Jul 2005 13:13:41 -0500 User-Agent: Microsoft-Entourage/11.1.0.040913 Date: Fri, 29 Jul 2005 10:13:41 -0700 Subject: Re: Performance problems testing with Spamassassin From: "Luke Lonergan" To: "Tom Lane" Cc: "Andrew McMillan" , "Matthew Schumacher" , pgsql-performance@postgresql.org Message-ID: In-Reply-To: <16614.1122646366@sss.pgh.pa.us> MIME-Version: 1.0 X-OriginalArrivalTime: 29 Jul 2005 17:13:41.0685 (UTC) FILETIME=[DE465650:01C59460] X-WSS-ID: 6EF4BC4F2B48612553-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.577 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, RCVD_NUMERIC_HELO X-Spam-Level: * X-Archive-Number: 200507/475 X-Sequence-Number: 13716 Tom, On 7/29/05 7:12 AM, "Tom Lane" wrote: > "Luke Lonergan" writes: >> I guess we see the real culprit here. Anyone surprised it's the WAL? > > You have not proved that at all. As Alvaro pointed out, fsync has impact on more than WAL, so good point. Interesting that fsync has such a huge impact on this situation though. - Luke