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 AE67E535AB for ; Tue, 5 Apr 2005 02:31:45 +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 37198-08 for ; Tue, 5 Apr 2005 01:31:35 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.200]) by svr1.postgresql.org (Postfix) with ESMTP id 4B1DC53397 for ; Tue, 5 Apr 2005 02:31:34 +0100 (BST) Received: by rproxy.gmail.com with SMTP id a41so1357549rng for ; Mon, 04 Apr 2005 18:31:39 -0700 (PDT) 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=tFirBHUdKLFkOL6AzSag4t/u1aDiiIxf8JFNc6RLWko7Gsz9XYw2ZGewqH9xqU2Jdw2SPjQ3BIg5SAXLjulpfYusPGqPdli+zhv7yhINhBCNTrGEAf8iqNYnIsG/o0rjtzULYTKLHxAKdnEAcCpMmMLwhtjzD3YT+7yWu2iSumA= Received: by 10.38.13.39 with SMTP id 39mr5838716rnm; Mon, 04 Apr 2005 18:31:38 -0700 (PDT) Received: by 10.38.207.41 with HTTP; Mon, 4 Apr 2005 18:31:38 -0700 (PDT) Message-ID: <59d991c405040418314b860fca@mail.gmail.com> Date: Mon, 4 Apr 2005 21:31:38 -0400 From: Christopher Petrilli Reply-To: Christopher Petrilli To: Simon Riggs Subject: Re: Sustained inserts per sec ... ? Cc: jd@commandprompt.com, Tom Lane , "Marc G. Fournier" , pgsql-performance@postgresql.org In-Reply-To: <1112654640.16721.859.camel@localhost.localdomain> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit References: <20050401140421.P18194@ganymede.hub.org> <59d991c4050401125956d6069d@mail.gmail.com> <59d991c40504040648457808e9@mail.gmail.com> <1112644015.16721.790.camel@localhost.localdomain> <59d991c4050404125611ad5af8@mail.gmail.com> <1112645479.16721.806.camel@localhost.localdomain> <59d991c405040413184699cfe1@mail.gmail.com> <1112648303.16721.816.camel@localhost.localdomain> <59d991c4050404140333bff1ed@mail.gmail.com> <1112654640.16721.859.camel@localhost.localdomain> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.307 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/74 X-Sequence-Number: 11471 On Apr 4, 2005 6:44 PM, Simon Riggs wrote: > Before I start to tunnel-vision on a particular coincidence... > > How much memory have you got on the system? Now, 2Gb, but most of it is free in this situation. Earlier, I posted some of the settings related to work mem. > How much of that have you allocated to various tasks? Do you mean inside PostgreSQL? > What else is happening on your system? sshd, that's it :-) > Tell us more about disk set-up and other hardware related things. > Disk cache...disk speed...seek times....etc Sure, here's the system configuration: * AMD64/3000 * 2GB RAM (was 1GB, has made no difference) * 1 x 120GB SATA drive (w/WAL), 7200RPM Seagate * 1 x 160GB SATA drive (main), 7200RPM Seagate Chris -- | Christopher Petrilli | petrilli@gmail.com