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.
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2005-06-13 16:22:14|
|Subject: Re: Index ot being used |
|Previous:||From: Yves Vindevogel||Date: 2005-06-13 15:49:47|
|Subject: Fwd: Updates on large tables are extremely slow |