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