Kevin Grittner <kgri...@wicourts.gov> wrote: > Maybe before I get excited I should try it with a query which is > actually logically equivalent. Fixed version: DELETE FROM foo where type = 'o' and foo.b in ( select b from foo WHERE type = 'o' except SELECT b FROM bar except SELECT b FROM foo where type <> 'o'); The change didn't affect run time significantly; it still beats the others. -Kevin
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
