MIME-Version: 1.0
References: <1932444f587.1098347f3276523.6403251539793861793@jasonic.dk>
In-Reply-To: <1932444f587.1098347f3276523.6403251539793861793@jasonic.dk>
From: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Date: Wed, 13 Nov 2024 12:43:20 +0530
Message-ID: <CAM+6J97Jd5WnxdyFu1-s+wvJrWPL_YvP3yeuQVwy3HJvK=KUTQ@mail.gmail.com>
Subject: Fwd: A million users
To: pgsql-general <pgsql-general@postgresql.org>, "kaare@jasonic.dk" <kaare@jasonic.dk>
Content-Type: multipart/alternative; boundary="0000000000001535f20626c612de"
Archived-At: <https://www.postgresql.org/message-id/CAM%2B6J97Jd5WnxdyFu1-s%2BwvJrWPL_YvP3yeuQVwy3HJvK%3DKUTQ%40mail.gmail.com>
Precedence: bulk

--0000000000001535f20626c612de
Content-Type: text/plain; charset="UTF-8"

---------- 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

--0000000000001535f20626c612de
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div><br><br><div class=3D"gmail_quote"><div dir=3D"ltr" =
class=3D"gmail_attr">---------- Forwarded message ---------<br>From: <stron=
g class=3D"gmail_sendername" dir=3D"auto">Kaare Rasmussen</strong> <span di=
r=3D"auto">&lt;&gt;</span><br></div><br><br>Hi<br>
<br>
A simple question before design.<br>
<br>
Would there be performance issues having perhaps a million users, each <br>
having several roles? I could imagine a user would have on average 10-20 <b=
r>
roles.<br>
<br>I tried to grant select permissions to 5000 different roles on one tabl=
e,</div><div class=3D"gmail_quote" dir=3D"auto">It failed with row size too=
 big already at 2443.</div><div class=3D"gmail_quote" dir=3D"auto"><br></di=
v><div class=3D"gmail_quote" dir=3D"auto">That said,</div><div class=3D"gma=
il_quote" dir=3D"auto">I am not even talking of catalog bloat.</div><div cl=
ass=3D"gmail_quote" dir=3D"auto">So please test ...I think there might be s=
ome doc that will show the limitations or in the source code, I can check l=
ater=C2=A0</div><div class=3D"gmail_quote" dir=3D"auto"><br>
<br>
<br>
</div></div></div>

--0000000000001535f20626c612de--