Speeding up an update over multiple tables

Vote count: 0

As you probably know, UPDATE INNER JOINS on postgres are not the best. I have gone back to the old way of updating across multiple tables but have come into some performance issues with the following query:

UPDATE table_a  a
SET    field1 = field4
FROM table_b b , table_c c 
WHERE a.field3 = b.field3 
AND a.field1  = c.field4
AND ((a.field1  Is Null) Or (a.field1 ='')) AND (a.field2 ='T'); 

Does anyone have a better/quicker way for running queries like this in postgres?

asked 36 secs ago

DazstaV3

Let's block ads! (Why?)

Speeding up an update over multiple tables