Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D974764FD20 for ; Mon, 29 Dec 2008 05:43:51 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10595-01 for ; Mon, 29 Dec 2008 05:43:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from shopzeus.com (135-shost.hostoffice.hu [195.228.74.135]) by mail.postgresql.org (Postfix) with ESMTP id ADFEF64FD19 for ; Mon, 29 Dec 2008 05:43:45 -0400 (AST) Received: from [192.168.1.104] (localhost [127.0.0.1]) by shopzeus.com (Postfix) with ESMTP id 14BC639243A; Mon, 29 Dec 2008 04:34:41 -0500 (EST) Message-ID: <49589BCE.5080201@shopzeus.com> Date: Mon, 29 Dec 2008 10:43:42 +0100 From: Laszlo Nagy User-Agent: Thunderbird 2.0.0.18 (X11/20081125) MIME-Version: 1.0 To: Tom Lane CC: Gregory Williamson , "pgsql-performance@postgresql.org" , Daniel Fekete Subject: Re: Slow table update References: <494F749A.5090603@shopzeus.com> <494F7B48.6070204@shopzeus.com> <8B319E5A30FF4A48BE7EEAAF609DB233021F389A@COMAIL01.digitalglobe.com> <494F8DFC.1000001@shopzeus.com> <7032.1229952622@sss.pgh.pa.us> In-Reply-To: <7032.1229952622@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.125 tagged_above=0 required=5 tests=DNS_FROM_RFC_BOGUSMX=2.125 X-Spam-Level: ** X-Archive-Number: 200812/220 X-Sequence-Number: 32256 >> My other idea was that there are so many indexes on this table, maybe >> the update is slow because of the indexes? >> > > Updating indexes is certainly very far from being free. How many is > "many"? > Number of indexes = 15. 3 indexex are on "text" type column, 500MB in size each. Other are on int8 and timestamp columns, cca. 200MB each.