Re: Update taking forever

From: Jan Otto <asche(at)me(dot)com>
To: Oliver Weichhold <oliver(at)weichhold(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Update taking forever
Date: 2008-08-15 13:57:28
Message-ID: 1923702A-762B-4C35-A18E-C926233B886D@me.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2008-08-15 14:34:44 Re: Confronting the maximum column limitation
Previous Message Andrew Sullivan 2008-08-15 13:46:00 Re: [Q] DNS(bind) ER model