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

2011-03-01 Thread Tom Lane
Bill Moran writes: > In response to Magnus Reftel : >> 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

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

2011-03-01 Thread Joshua D. Drake
On Tue, 2011-03-01 at 15:57 -0500, Bill Moran wrote: > In response to Magnus Reftel : > > > > I'm working on a database that will have a very large number of users, and > > I'm running in to a problem: when I grant more than about 2500 users access > > to a schema, I get > > > > my_db=# grant u

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

2011-03-01 Thread Magnus Reftel
On Mar 1, 2011, at 21:57 , Bill Moran wrote: > In response to Magnus Reftel : >> >> I'm working on a database that will have a very large number of users, and >> I'm running in to a problem: when I grant more than about 2500 users access >> to a schema, I get >> >> my_db=# grant usage on schem

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

2011-03-01 Thread Bill Moran
In response to Magnus Reftel : > > I'm working on a database that will have a very large number of users, and > I'm running in to a problem: when I grant more than about 2500 users access > to a schema, I get > > my_db=# grant usage on schema my_schema to some_user; > ERROR: row is too big: si

[GENERAL] Thousands of users using one schema -> ERROR: row is too big

2011-03-01 Thread Magnus Reftel
Hi all, I'm working on a database that will have a very large number of users, and I'm running in to a problem: when I grant more than about 2500 users access to a schema, I get my_db=# grant usage on schema my_schema to some_user; ERROR: row is too big: size 8168, maximum size 8164 This of c