I need to merge 2 tables: update d set c1=s.c1, c2=s.c2... from s where d.pk=s.pk; insert into d (pk, c1, c2, ...) select pk, c1, c2, c3 from s where s.pk not in (select pk from d); Any strategy to make it faster? Including modifying postgres.conf temporary? Considering I've no concurrency problems. The tables I'm dealing with are "read only" for everything else other than the merge process. thanks -- Ivan Sergio Borgonovo http://www.webthatworks.it
