Craig James <craig_james@xxxxxxxxxxxxxx> writes: > Maybe this is an obviously dumb thing to do, but it looked reasonable > to me. The problem is, the seemingly simple sort below causes a > fairly powerful computer to completely freeze for 5-10 minutes. trace_sort output might be informative. 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