On 10/19/07, Pavel Velikhov <[EMAIL PROTECTED]> wrote: > > Hi, > > I am updating a big table (90M records) with data from another rather > large table (4M entries). Here is my update query: > > update links set target_size = > ( select size from articles where articles.article_id = > links.article_to)
try: UPDATE links SET target_size = size FROM articles WHERE articles.article_id = links.article_to; -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | [EMAIL PROTECTED] Edison, NJ 08837 | http://www.enterprisedb.com/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
