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 7034852A2F; Fri, 1 Apr 2005 23:04:03 +0100 (BST) 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 75983-02; Fri, 1 Apr 2005 22:03:56 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 13DB053A54; Fri, 1 Apr 2005 23:03:55 +0100 (BST) 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 j31M3rMR029022; Fri, 1 Apr 2005 17:03:53 -0500 (EST) To: Alex Turner Cc: "Marc G. Fournier" , pgsql-performance@postgresql.org Subject: Re: Sustained inserts per sec ... ? In-reply-to: <33c6269f050401132052019918@mail.gmail.com> References: <20050401140421.P18194@ganymede.hub.org> <33c6269f05040113175b47b640@mail.gmail.com> <33c6269f050401132052019918@mail.gmail.com> Comments: In-reply-to Alex Turner message dated "Fri, 01 Apr 2005 16:20:46 -0500" Date: Fri, 01 Apr 2005 17:03:53 -0500 Message-ID: <29021.1112393033@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/24 X-Sequence-Number: 11421 Alex Turner writes: > On Apr 1, 2005 4:17 PM, Alex Turner wrote: >> 1250/sec with record size average is 26 bytes >> 800/sec with record size average is 48 bytes. >> 250/sec with record size average is 618 bytes. > Oh - this is with a seperate transaction per command. > fsync is on. [ raised eyebrow... ] What kind of disk hardware is that exactly, and does it have write cache enabled? It's hard to believe those numbers if not. Write caching is fine if it's done in a battery-backed cache, which you can get in the higher-end hardware RAID controllers. Otherwise you're going to have problems whenever the power goes away unexpectedly. regards, tom lane