Re: Memory usage during sorting

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Memory usage during sorting
Дата
Msg-id 8727.1332085547@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Memory usage during sorting  (Jeremy Harris <jgh@wizmail.org>)
Список pgsql-hackers
Jeremy Harris <jgh@wizmail.org> writes:
> On 2012-03-18 15:25, Tom Lane wrote:
>> Yeah, that was me, and it came out of actual user complaints ten or more
>> years back.  (It's actually not 2X growth but more like 4X growth
>> according to the comments in logtape.c, though I no longer remember the
>> exact reasons why.)  We knew when we put in the logtape logic that we
>> were trading off speed for space, and we accepted that.

> How about a runtime check of disk-free?

Not very workable, the foremost reason why not being that it assumes
that the current sort is the only thing consuming disk space.  I'm not
sure there is any portable method of finding out how much disk space
is available, anyway.  (Think user quotas and such before supposing
you know how to do that.)
        regards, tom lane


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Recent MinGW postgres builds with -O2 do not pass regression tests
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Memory usage during sorting