Re: High update activity, PostgreSQL vs BigDBMS

Поиск
Список
Период
Сортировка
От Arnau
Тема Re: High update activity, PostgreSQL vs BigDBMS
Дата
Msg-id 45952587.5060603@andromeiberica.com
обсуждение исходный текст
Ответ на Re: High update activity, PostgreSQL vs BigDBMS  (Ron <rjpeace@earthlink.net>)
Список pgsql-performance
Hi all,

> A= go through each query and see what work_mem needs to be for that
> query to be as RAM resident as possible.  If you have enough RAM, set
> work_mem for that query that large.  Remember that work_mem is =per
> query=, so queries running in parallel eat the sum of each of their
> work_mem's.

How can I know what work_mem needs a query needs?

Regards
--
Arnau

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

Предыдущее
От: Ron
Дата:
Сообщение: Re: High update activity, PostgreSQL vs BigDBMS
Следующее
От: Sebastián Baioni
Дата:
Сообщение: Backup/Restore too slow