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 console. I'm guessing you're piping
the output into something.
Probably it's psql that is choking from bu
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.
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 conso
Craig James wrote:
Maybe this is an obviously dumb thing to do,
... and it was. I answered my own question: The problem came from using
psql(1) to do something I should have done with pg_dump.
but it looked reasonable to
me. The problem is, the seemingly simple sort below causes a fairly
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 A
