Home > mailing lists

Fwd: A million users - Mailing list pgsql-general

From	Vijaykumar Jain
Subject	Fwd: A million users
Date	November 13 13:13:20
Msg-id	CAM+6J97Jd5WnxdyFu1-s+wvJrWPL_YvP3yeuQVwy3HJvK=KUTQ@mail.gmail.com Whole thread Raw
In response to	A million users (Kaare Rasmussen <kaare@jasonic.dk>)
Responses	Re: Fwd: A million users
List	pgsql-general

Tree view

---------- Forwarded message ---------
From: Kaare Rasmussen <>

Hi

A simple question before design.

Would there be performance issues having perhaps a million users, each
having several roles? I could imagine a user would have on average 10-20
roles.

I tried to grant select permissions to 5000 different roles on one table,

It failed with row size too big already at 2443.

That said,

I am not even talking of catalog bloat.

So please test ...I think there might be some doc that will show the limitations or in the source code, I can check later

pgsql-general by date:

From: Kaare Rasmussen
Date: 13 November, 12:45:19
Subject: A million users

From: Jayadevan M
Date: 13 November, 14:45:29
Subject: Re: PostgreSQL logical replication

Fwd: A million users - Mailing list pgsql-general

Previous

Next