Re: Fwd: Updates on large tables are extremely slow

From: Richard Huxton <dev(at)archonet(dot)com>
To: Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Fwd: Updates on large tables are extremely slow
Date: 2005-06-13 16:02:24
Message-ID: 42ADAE10.6050204@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Yves Vindevogel wrote:
> I forgot cc
>
> Begin forwarded message:
>
>> From: Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be>
>> Date: Mon 13 Jun 2005 17:45:19 CEST
>> To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-06-13 16:22:14 Re: Index ot being used
Previous Message Yves Vindevogel 2005-06-13 15:49:47 Fwd: Updates on large tables are extremely slow