Re: Thousands of users using one schema -> ERROR: row is too big

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Thousands of users using one schema -> ERROR: row is too big
Дата
Msg-id 27519.1299015958@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Thousands of users using one schema -> ERROR: row is too big  (Bill Moran <wmoran@potentialtech.com>)
Список pgsql-general
Bill Moran <wmoran@potentialtech.com> writes:
> In response to Magnus Reftel <magnus.reftel@gmail.com>:
>> On IRC, linuxpoet and andres suggested that the problem is that the
> nspacl column in pg_catalog.pg_namespace grows too large. A suggested
> fix by linuxpoet adds a toast table to pg_namespace.

> I would think that a better solution would be to follow best practices and
> create roles and put users in those roles, so you don't have to have so
> many grants on objects.

Yeah.  You could probably get around it with the add-a-toast-table hack,
but I think performance would be a lot worse.

            regards, tom lane

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Thousands of users using one schema -> ERROR: row is too big
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: #PgEast Training Schedule Up