Re: PostgreSQL performance problem -> tuning

Поиск
Список
Период
Сортировка
От Dennis Björklund
Тема Re: PostgreSQL performance problem -> tuning
Дата
Msg-id Pine.LNX.4.44.0308071020110.26410-100000@zigo.dhs.org
обсуждение исходный текст
Ответ на Re: PostgreSQL performance problem -> tuning  (Richard Huxton <dev@archonet.com>)
Список pgsql-performance
On Thu, 7 Aug 2003, Richard Huxton wrote:

> But this parameter controls how much memory can be allocated to sorts - I
> don't see how PG can figure out a reasonable maximum by itself.

One could have one setting for the total memory usage and pg could use
statistics or some heuristics to use the memory for different things in a
good way.

Then that setting could have an auto setting so it uses 40% of all memory
or something like that. Not perfect but okay for most people.

--
/Dennis


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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: PostgreSQL performance problem -> tuning
Следующее
От: Yaroslav Mazurak
Дата:
Сообщение: Re: PostgreSQL performance problem -> tuning