Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group