X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 91A36DB6CB for ; Tue, 1 Nov 2005 13:25:08 -0400 (AST) 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 80423-10 for ; Tue, 1 Nov 2005 17:24:53 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id EAECADB6A4 for ; Tue, 1 Nov 2005 13:24:52 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id jA1HOheB026530; Tue, 1 Nov 2005 12:24:43 -0500 (EST) To: Jon Brisbin Cc: pgsql-performance@postgresql.org Subject: Re: 8.1beta3 performance In-reply-to: <20051101085037.1b12b077@fc63r41.npci.com> References: <20051101085037.1b12b077@fc63r41.npci.com> Comments: In-reply-to Jon Brisbin message dated "Tue, 01 Nov 2005 08:50:37 -0600" Date: Tue, 01 Nov 2005 12:24:43 -0500 Message-ID: <26529.1130865883@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.006 required=5 tests=[AWL=0.006] X-Spam-Score: 0.006 X-Spam-Level: X-Archive-Number: 200511/10 X-Sequence-Number: 15267 Jon Brisbin writes: > I have a stock FreeBSD 5.4 box that I put 8.1 on last night. I ran > pgbench against it and my tps dropped from ~300tps in 8.0.3 to 20tps > in 8.1. That's right. 20. No changes in any system configuration. You sure about that last? These numbers are kind of consistent with the idea that fsync is off in the 8.0 database and on in the 8.1 database. Using the same test case you mention (pgbench -s 10, -c 25 -t 1000), I find that 8.1 is a bit faster than 8.0, eg 8.1 fsync off: tps = 89.831186 (including connections establishing) tps = 89.865065 (excluding connections establishing) 8.1 fsync on: tps = 74.865078 (including connections establishing) tps = 74.889066 (excluding connections establishing) 8.0 fsync off: tps = 80.271338 (including connections establishing) tps = 80.302054 (excluding connections establishing) 8.0 fsync on: tps = 67.405708 (including connections establishing) tps = 67.426546 (excluding connections establishing) (All database parameters are defaults except fsync.) These numbers are with assert-enabled builds, on a cheap PC whose drive lies about write-complete, so they're not very representative of the real world I suppose. But I'm sure not seeing any 10x degradation. regards, tom lane