Re: Updates on large tables are extremely slow - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: Updates on large tables are extremely slow
Date
Msg-id 42ACF2DD.8090409@paradise.net.nz
Whole thread Raw
In response to Updates on large tables are extremely slow  (Yves Vindevogel <yves.vindevogel@implements.be>)
List pgsql-performance
Yves Vindevogel wrote:
>
> I'm trying to update a table that has about 600.000 records.
> The update query is very simple : update mytable set pagesdesc = - pages ;
>
> The query takes about half an hour to an hour to execute. I have tried a
> lot of things.
>

Half an hour seem a bit long - I would expect less than 5 minutes on
reasonable hardware.

You may have dead tuple bloat - can you post the output of 'ANALYZE
VERBOSE mytable' ?

Cheers

Mark

pgsql-performance by date:

Previous
From: elein@varlena.com (elein)
Date:
Subject: Resource Requirements
Next
From: Bruno Wolff III
Date:
Subject: Re: Index ot being used