Maciek Sakrejda <m.sakrejda@xxxxxxxxx> writes: > Presumably something like this?: > maciek=# CREATE TABLE test AS SELECT g, random() FROM > generate_series(1,1000) g; > CREATE > maciek=# EXPLAIN DELETE FROM test USING (SELECT g FROM test ORDER BY > ctid) x where x.g = test.g; There's no guarantee that the planner won't re-sort the rows coming from the sub-select, unfortunately. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
