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

Bill Moran <wmoran(at)potentialtech(dot)com> writes:
> In response to Magnus Reftel <magnus(dot)reftel(at)gmail(dot)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