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 4C2BC539C9 for ; Fri, 1 Apr 2005 22:17:23 +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 62911-06 for ; Fri, 1 Apr 2005 21:17:20 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.193]) by svr1.postgresql.org (Postfix) with ESMTP id 81430533EB for ; Fri, 1 Apr 2005 22:17:17 +0100 (BST) Received: by wproxy.gmail.com with SMTP id 68so1097946wri for ; Fri, 01 Apr 2005 13:17:19 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=roPcXjxaijxjeiOkiu7N2HnYXiVapKYBGZuAPGWR/riSq+GwGUex3vC2o8IJUKem5wtK8Ys27fBkC5cv+pHuMWHj0ZiSFrKR2zj697GJVbMLomenUIInMgNunbfxIwcCqBC3TMHi/VkEvcUIq5mcZGKcNv9+l+FwWGoCUePa7p8= Received: by 10.54.66.17 with SMTP id o17mr116520wra; Fri, 01 Apr 2005 13:17:19 -0800 (PST) Received: by 10.54.86.16 with HTTP; Fri, 1 Apr 2005 13:17:19 -0800 (PST) Message-ID: <33c6269f05040113175b47b640@mail.gmail.com> Date: Fri, 1 Apr 2005 16:17:19 -0500 From: Alex Turner Reply-To: Alex Turner To: "Marc G. Fournier" Subject: Re: Sustained inserts per sec ... ? Cc: pgsql-performance@postgresql.org In-Reply-To: <20050401140421.P18194@ganymede.hub.org> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit References: <20050401140421.P18194@ganymede.hub.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.241 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/21 X-Sequence-Number: 11418 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. Data from pg_stats and our own job monitoring System has four partitions, two raid 1s, a four disk RAID 10 and a six disk RAID 10. pg_xlog is on four disk RAID 10, database is on RAID 10. Data is very spread out because database turnover time is very high, so our performance is about double this with a fresh DB. (the data half life is probably measurable in days or weeks). Alex Turner netEconomist On Apr 1, 2005 1:06 PM, Marc G. Fournier wrote: > > Just curious, but does anyone have an idea of what we are capable of? I > realize that size of record would affect things, as well as hardware, but > if anyone has some ideas on max, with 'record size', that would be > appreciated ... > > Thanks ... > > ---- > Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) > Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664 > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend >