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 3E1EB5338F for ; Mon, 4 Apr 2005 22:04:14 +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 65174-06 for ; Mon, 4 Apr 2005 21:04:10 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.205]) by svr1.postgresql.org (Postfix) with ESMTP id 58BD653225 for ; Mon, 4 Apr 2005 22:03:54 +0100 (BST) Received: by rproxy.gmail.com with SMTP id a41so1317556rng for ; Mon, 04 Apr 2005 14:03:56 -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=jpVIbmXX1hYenVGmPDCZqyfCZQjkhFKMc9gIS9VUnfh2YAt81xyCCFbrvLg/kflG3CQgOMgrZb7hc2QocRyZtpM2ss2D0vfPppqzwPr2AwCUl5AqZK6kPUlJVq1JI5S4K1si/v8cXEOgK6lAH8LM4CsTrR58zi6fiiftSd3Rbj4= Received: by 10.38.13.39 with SMTP id 39mr5645258rnm; Mon, 04 Apr 2005 14:03:56 -0700 (PDT) Received: by 10.38.207.41 with HTTP; Mon, 4 Apr 2005 14:03:56 -0700 (PDT) Message-ID: <59d991c4050404140333bff1ed@mail.gmail.com> Date: Mon, 4 Apr 2005 17:03:56 -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: <1112648303.16721.816.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> <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> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.302 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/69 X-Sequence-Number: 11466 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. Chris -- | Christopher Petrilli | petrilli@gmail.com