Postgres Pro
Downloads
Home   >   mailing lists

Re: Updates on large tables are extremely slow - Mailing list pgsql-performance

From Jacques Caron
Subject Re: Updates on large tables are extremely slow
Date
Msg-id 6.2.0.14.0.20050613193502.039de7c8@pop.interactivemediafactory.net
Whole thread Raw
In response to Re: Updates on large tables are extremely slow  (Yves Vindevogel <yves.vindevogel@implements.be>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Yves Vindevogel
Date:
Subject: Re: Updates on large tables are extremely slow
Next
From: Madison Kelly
Date:
Subject: Re: Index ot being used