Postgres Pro
Downloads
Home   >   mailing lists

Re: Sort causes system to freeze - Mailing list pgsql-performance

From Tom Lane
Subject Re: Sort causes system to freeze
Date
Msg-id 13978.1228214053@sss.pgh.pa.us
Whole thread Raw
In response to Sort causes system to freeze  (Craig James <craig_james@emolecules.com>)
List pgsql-performance
Tree view 
Craig James <craig_james@emolecules.com> 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

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Sort causes system to freeze
Next
From: PFC
Date:
Subject: Re: Sort causes system to freeze