Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 6F1314BB8EB for ; Wed, 4 Apr 2012 14:00:07 -0300 (ADT) Received: from [2001:1528:137::f1] (helo=mail.gransy.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SFTYx-00054w-84 for pgsql-performance@postgresql.org; Wed, 04 Apr 2012 17:00:06 +0000 Received: from antispam.gransy.com (antispam.gransy.com [77.78.104.124]) by mail.gransy.com (Postfix) with ESMTP id 0561A508648 for ; Wed, 4 Apr 2012 18:59:51 +0200 (CEST) Received: from mail.gransy.com ([82.208.29.194]) by antispam.gransy.com (antispam.gransy.com [77.78.104.124]) (amavisd-new, port 10024) with ESMTP id W7RpVX5xSwvc for ; Wed, 4 Apr 2012 18:59:50 +0200 (CEST) Received: by mail.gransy.com (Postfix, from userid 5000) id E6C7E5086B4; Wed, 4 Apr 2012 18:59:50 +0200 (CEST) Received: from [192.168.1.237] (ip-78-45-133-255.net.upcbroadband.cz [78.45.133.255]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.gransy.com (Postfix) with ESMTPSA id C2FD3508648 for ; Wed, 4 Apr 2012 18:59:50 +0200 (CEST) Message-ID: <4F7C7E07.1050507@fuzzy.cz> Date: Wed, 04 Apr 2012 18:59:51 +0200 From: Tomas Vondra User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:11.0) Gecko/20120312 Thunderbird/11.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: about multiprocessingmassdata References: <2012040423524938620013@gmail.com>, <4F7C7827.7080705@fuzzy.cz> <2012040500491136389424@gmail.com> In-Reply-To: <2012040500491136389424@gmail.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Host-Lookup-Failed: Reverse DNS lookup failed for 2001:1528:137::f1 (failed) X-Pg-Spam-Score: -1.1 (-) X-Archive-Number: 201204/48 X-Sequence-Number: 46694 On 4.4.2012 18:49, superman0920 wrote: > Thank you for your reply > I tried executing "UPDATE poi SET py = replace(py, ' ','');", that took > long long time(about 20+ hours) and no error report. Just like locked. OK, that's weird. So we need a bit more details - what PostgreSQL version is this? How much space does the table actually occupy? Try this: SELECT relname, relpages, reltuples FROM pg_class WHERE relname = 'poi'; And finally we need EXPLAIN output for both UPDATE commands. Don't post them here directly - put them to explain.depesz.com and post just the link. Further, we need to see the actual table definition. Especially if there are any triggers or foreign keys on the table? Tomas