Re: maintenance_work_mem memory constraint?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: maintenance_work_mem memory constraint?
Дата
Msg-id 23458.1196100134@sss.pgh.pa.us
обсуждение исходный текст
Ответ на maintenance_work_mem memory constraint?  (Bernd Helmle <mailings@oopsware.de>)
Ответы Re: maintenance_work_mem memory constraint?  (Bernd Helmle <mailings@oopsware.de>)
Список pgsql-hackers
Bernd Helmle <mailings@oopsware.de> writes:
> ... But isn't it worth to special case the 
> code in grow_memtuples() (and maybe other places where sort is likely to 
> use more RAM), so that we can remove this constraint on 64-Bit systems with 
> many RAM built in? Or am I missing something very important?.

AFAICS this patch can increase the number of sortable tuples by at most 2X
(less one).  That doesn't seem worth getting very worked up about ...
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 8.3devel slower than 8.2 under read-only load
Следующее
От:
Дата:
Сообщение: Re: Replacement Selection