Re: Slow update statement

From: Tom Lane
Subject: Re: Slow update statement
Date: ,
Msg-id: 17916.1123337563@sss.pgh.pa.us
(view: Whole thread, Raw)
In response to: Slow update statement  (Patrick Hatcher)
Responses: Re: Slow update statement  (Patrick Hatcher)
List: pgsql-performance

Tree view

Slow update statement  (Patrick Hatcher, )
 Re: Slow update statement  (John A Meinel, )
  Re: Slow update statement  (Patrick Hatcher, )
   Re: Slow update statement  (Tom Lane, )
    Re: Slow update statement  (Patrick Hatcher, )
 Re: Slow update statement  (Tom Lane, )
  Re: Slow update statement  (Patrick Hatcher, )
   Re: Slow update statement  (Tom Lane, )

Patrick Hatcher <> writes:
> I'm running an update statement on about 12 million records using the
> following query:

> Update table_A
> set F1 = b.new_data
> from table_B b
> where b.keyfield = table_A.keyfield

What does EXPLAIN show for this?

Do you have any foreign key references to table_A from elsewhere?

            regards, tom lane


pgsql-performance by date:

From: Tom Lane
Date:
Subject: Re: Slow update statement
From: Patrick Hatcher
Date:
Subject: Re: Slow update statement