Postgres Pro
Downloads
Home   >   mailing lists

Re: Update taking forever - Mailing list pgsql-general

From Jan Otto
Subject Re: Update taking forever
Date
Msg-id 1923702A-762B-4C35-A18E-C926233B886D@me.com
Whole thread Raw
In response to Update taking forever  ("Oliver Weichhold" <oliver@weichhold.com>)
List pgsql-general
Tree view 
Hi Oliver,

> currently idle except for the update statement. Any suggestions why
> it takes so long to update a couple million rows?
>
> update characters set last_update = null

Try to update only rows that not already null.

update characters set last_update = null where last_update is not null;

Jan

pgsql-general by date:

Previous
From: "Dot Yet"
Date:
Subject: Horology test failure while compiling PostgreSQL 8.3.3 on Solaris 10 x64
Next
From: Tom Lane
Date:
Subject: Re: Regression failing on build -> ERROR: could not access file "$libdir/plpgsql": No such file or directory