Fwd: A million users

From: Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>, "kaare(at)jasonic(dot)dk" <kaare(at)jasonic(dot)dk>
Subject: Fwd: A million users
Date: 2024-11-13 07:13:20
Message-ID: CAM+6J97Jd5WnxdyFu1-s+wvJrWPL_YvP3yeuQVwy3HJvK=KUTQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jayadevan M 2024-11-13 08:45:29 Re: PostgreSQL logical replication
Previous Message Kaare Rasmussen 2024-11-13 06:45:19 A million users