Re: Sort causes system to freeze

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Craig James <craig_james(at)emolecules(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Sort causes system to freeze
Date: 2008-12-02 10:34:13
Message-ID: 13978.1228214053@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Craig James <craig_james(at)emolecules(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2008-12-02 11:54:22 Re: Sort causes system to freeze
Previous Message Daniel Cristian Cruz 2008-12-02 10:10:14 Re: Not so simple query and a half million loop