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 1DE025364E; Mon, 4 Apr 2005 23:46:02 +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 95643-02; Mon, 4 Apr 2005 22:45:52 +0000 (GMT) Received: from cmailg1.svr.pol.co.uk (cmailg1.svr.pol.co.uk [195.92.195.171]) by svr1.postgresql.org (Postfix) with ESMTP id 4217B533AE; Mon, 4 Apr 2005 23:45:51 +0100 (BST) Received: from modem-3427.lion.dialup.pol.co.uk ([217.135.173.99] helo=192.168.0.102) by cmailg1.svr.pol.co.uk with esmtp (Exim 4.14) id 1DIaKM-0005cD-JA; Mon, 04 Apr 2005 23:45:50 +0100 Subject: Re: Sustained inserts per sec ... ? From: Simon Riggs To: Christopher Petrilli Cc: jd@commandprompt.com, Tom Lane , "Marc G. Fournier" , pgsql-performance@postgresql.org In-Reply-To: <59d991c4050404140333bff1ed@mail.gmail.com> References: <20050401140421.P18194@ganymede.hub.org> <59d991c4050401124638c4ab5d@mail.gmail.com> <1112388818.3487.34.camel@jd2.commandprompt.com> <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> Content-Type: text/plain Organization: 2nd Quadrant Date: Mon, 04 Apr 2005 23:44:00 +0100 Message-Id: <1112654640.16721.859.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-3) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.048 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/70 X-Sequence-Number: 11467 On Mon, 2005-04-04 at 17:03 -0400, Christopher Petrilli wrote: > On Apr 4, 2005 4:58 PM, Simon Riggs wrote: > > Can you do: > > select relname from pg_class where relfilenode = 26488271 > > and confirm that the name is the table you've been loading... > > It is. > > > Couldn't see all your indexes... are they still there? > > Nope, I'm running a second run without the auxilary indices. I only > have the primary key index. So far, a quick scan with the eye says > that it's behaving "better", but beginning to have issues again. I'll > post results as soon as they are done. Hmmm.... Before I start to tunnel-vision on a particular coincidence... How much memory have you got on the system? How much of that have you allocated to various tasks? What else is happening on your system? Tell us more about disk set-up and other hardware related things. Disk cache...disk speed...seek times....etc Best Regards, Simon Riggs