Re: Updates on large tables are extremely slow

From: Jacques Caron <jc(at)directinfos(dot)com>
To: Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Updates on large tables are extremely slow
Date: 2005-06-13 17:36:45
Message-ID: 6.2.0.14.0.20050613193502.039de7c8@pop.interactivemediafactory.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

At 19:22 13/06/2005, Yves Vindevogel wrote:
>It can't be indexes on other tables, right ?

It could be foreign keys from that table referencing other tables or
foreign keys from other tables referencing that table, especially if you
don't have the matching indexes...

Jacques.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Madison Kelly 2005-06-13 17:50:51 Re: Index ot being used
Previous Message Yves Vindevogel 2005-06-13 17:22:07 Re: Updates on large tables are extremely slow