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

From Richard Huxton
Subject Re: Fwd: Updates on large tables are extremely slow
Date
Msg-id 42ADAE10.6050204@archonet.com
Whole thread Raw
In response to Fwd: Updates on large tables are extremely slow  (Yves Vindevogel <yves.vindevogel@implements.be>)
Responses Re: Updates on large tables are extremely slow
List pgsql-performance
Yves Vindevogel wrote:
> I forgot cc
>
> Begin forwarded message:
>
>> From: Yves Vindevogel <yves.vindevogel@implements.be>
>> Date: Mon 13 Jun 2005 17:45:19 CEST
>> To: Tom Lane <tgl@sss.pgh.pa.us>
>> Subject: Re: [PERFORM] Updates on large tables are extremely slow
>>
>> Yes, but if I update one column, why should PG update 21 indexes ?
>> There's only one index affected !

No - all 21 are affected. MVCC creates a new row on disk.

--
   Richard Huxton
   Archonet Ltd

pgsql-performance by date:

Previous
From: Yves Vindevogel
Date:
Subject: Fwd: Updates on large tables are extremely slow
Next
From: Tom Lane
Date:
Subject: Re: Index ot being used