Re: Problems with memory

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Problems with memory
Дата
Msg-id b42b73150805071144y11fc8600nde2fa33a753fa102@mail.gmail.com
обсуждение исходный текст
Ответ на Problems with memory  ("Pau Marc Munoz Torres" <paumarc@gmail.com>)
Ответы Re: Problems with memory
Список pgsql-general
On Wed, May 7, 2008 at 11:55 AM, Pau Marc Munoz Torres
<paumarc@gmail.com> wrote:
> Hi
>
>  I'm setting up a big database , and when i say big, i mean BIG, the problem
> with this is that some times, when a do a query the database run out of
> memory, so I really need to increase the amount of memory reserved to
> postgress almost 10x, could anyone tell me how can i do that? i mean, what
> configuration file and variables do i have to modify?

All available memory of the machine is automatically reserved for the
database by the operating system, more or less.   At most you can
reserve memory for certain particular operations of the database at
the expense of others.

merlin

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Pl/;perl
Следующее
От: Michael Enke
Дата:
Сообщение: pg_dumpall: pg_conversion table not saved