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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly