On Thursday, September 06, 2012 05:06:27 PM Jeff Janes wrote: > For updating 20 million out of 500 million rows, wouldn't a full table > scan generally be preferable to an index scan anyway? > Not one table scan for each row updated ... -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general