Kevin Grittner <Kgrittn@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
