Re: Insert speed question

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Insert speed question
Дата
Msg-id 40BC44D3.6030309@archonet.com
обсуждение исходный текст
Ответ на Re: Insert speed question  (Gaetano Mendola <mendola@bigfoot.com>)
Список pgsql-general
Gaetano Mendola wrote:
> Josué Maldonado wrote:
>
>> sort_mem = 131072               # min 64, size in KB
>
>
> 128 MB for sort_mem is really an huge ammount of
> memory considering that is not system-wide but
> almost for process ( under certain operations a
> single process can use more then this quantity ).
> Hackers: am I wrong ?

Not a hacker, but you're right. It's the amount of memory *per sort*. Of
course, Josue might have a Terabyte of RAM but it's unlikely.

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Connecting to an External DB (repost)
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Separating application from data