Re: query against pg_locks leads to large memory alloc

Поиск

Список

Период

Сортировка

От	Andres Freund
Тема	Re: query against pg_locks leads to large memory alloc
Дата	19 августа 2014 г. 17:17:20
Msg-id	20140819171710.GA15735@awork2.anarazel.de обсуждение
Ответ на	Re: query against pg_locks leads to large memory alloc (Dave Owens <dave@teamunify.com>)
Ответы	Re: query against pg_locks leads to large memory alloc
Список	pgsql-performance

Дерево обсуждения

On 2014-08-18 14:36:52 -0700, Dave Owens wrote:
> On Mon, Aug 18, 2014 at 2:21 PM, Matheus de Oliveira
> <matioli.matheus@gmail.com> wrote:
> > Do you really need such large values? What is your max_connections value?
>
> max_connections = 450 ...we have found that we run out of shared
> memory when max_pred_locks_per_transaction is less than 30k.

What was the precise error message when that happened?

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Re: query against pg_locks leads to large memory alloc