From: Tomas Vondra <tv@fuzzy.cz>
To: pgsql-performance@postgresql.org
Subject: Re: about multiprocessingmassdata
Date: Wed, 04 Apr 2012 18:59:51 +0200
Message-ID: <4F7C7E07.1050507@fuzzy.cz> (raw)
In-Reply-To: <2012040500491136389424@gmail.com>
References: <2012040423524938620013@gmail.com>
<4F7C7827.7080705@fuzzy.cz>
<2012040500491136389424@gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tv@fuzzy.cz
Subject: Re: about multiprocessingmassdata
In-Reply-To: <4F7C7E07.1050507@fuzzy.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox