Re: Sort causes system to freeze

Поиск
Список
Период
Сортировка
От PFC
Тема Re: Sort causes system to freeze
Дата
Msg-id op.uli90wskcigqcu@soyouz
обсуждение исходный текст
Ответ на Re: Sort causes system to freeze  (Richard Huxton <dev@archonet.com>)
Список pgsql-performance
>> 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 buffering the rows.
    If you want to fetch that huge amount of data into a user application, a
CURSOR is the best way to do so.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Sort causes system to freeze
Следующее
От: "Andrus"
Дата:
Сообщение: analyzing intermediate query