Re: Thousands of users using one schema -> ERROR: row is too big - Mailing list pgsql-general

From Tom Lane
Subject Re: Thousands of users using one schema -> ERROR: row is too big
Date
Msg-id 27519.1299015958@sss.pgh.pa.us
Whole thread Raw
In response to Re: Thousands of users using one schema -> ERROR: row is too big  (Bill Moran <wmoran@potentialtech.com>)
List 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 by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Thousands of users using one schema -> ERROR: row is too big
Next
From: "Joshua D. Drake"
Date:
Subject: #PgEast Training Schedule Up