Re: [PERFORM] Sort causes system to freeze

2008-12-02 Thread Tom Lane
Craig James [EMAIL PROTECTED] 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.

Re: [PERFORM] Sort causes system to freeze

2008-12-02 Thread Richard Huxton
Don't reply to another message when starting a new thread. People will miss your message. Craig James wrote: Maybe this is an obviously dumb thing to do, but it looked reasonable to me. Looks reasonable here too - except I'm not sure what I'd do with 2 million rows of sorted table in my

[PERFORM] Sort causes system to freeze

2008-12-01 Thread Craig James
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. During the sort, you can't login, you can't use any shell sessions you already have open, the