Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 041602E0033 for ; Wed, 4 Jun 2008 17:15:30 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 51757-04 for ; Wed, 4 Jun 2008 17:15:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from pih-relay05.plus.net (pih-relay05.plus.net [212.159.14.132]) by developer.postgresql.org (Postfix) with ESMTP id A1DB82E0035 for ; Wed, 4 Jun 2008 17:15:23 -0300 (ADT) Received: from [80.229.150.39] (helo=pd600.barnhouse) by pih-relay05.plus.net with esmtp (Exim) id 1K3zOC-0004H4-9O; Wed, 04 Jun 2008 21:15:20 +0100 Received: from [192.168.0.87] (unknown [192.168.0.87]) by pd600.barnhouse (Postfix) with ESMTP id C70434E1C2B; Wed, 4 Jun 2008 21:22:04 +0100 (BST) Message-ID: <4846F90A.7030700@mansionfamily.plus.com> Date: Wed, 04 Jun 2008 21:20:26 +0100 From: James Mansion Organization: MsgWare User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: andrew klassen CC: pgsql-performance@postgresql.org Subject: Re: insert/update tps slow with indices on table > 1M rows References: <880373.23550.qm@web37305.mail.mud.yahoo.com> In-Reply-To: <880373.23550.qm@web37305.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Plusnet-Relay: 1482fead5d3a94395c1c05bea1b894b5 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/28 X-Sequence-Number: 30378 andrew klassen wrote: > I'll try adding more threads to update the table as you suggest. You could try materially increasing the update batch size too. As an exercise you could see what the performance of COPY is by backing out the data and reloading it from a suitable file.