Date: Wed, 13 Nov 2024 13:41:53 +0100
From: Kaare Rasmussen <kaare@jasonic.dk>
To: "Dominique Devienne" <ddevienne@gmail.com>,
	"Alvaro Herrera" <alvherre@alvh.no-ip.org>
Cc: "Vijaykumar Jain" <vijaykumarjain.github@gmail.com>,
	"pgsql-general" <pgsql-general@postgresql.org>
Message-Id: <193258b6791.ada07c1761341.959628411447004614@jasonic.dk>
In-Reply-To: <CAFCRh-9Le3fkJMWGuHdFPP-kfHdEAAchFZf0msEq3hNijixbFw@mail.gmail.com>
References: <CAM+6J97Jd5WnxdyFu1-s+wvJrWPL_YvP3yeuQVwy3HJvK=KUTQ@mail.gmail.com>
 <202411131029.qchduffwgzhm@alvherre.pgsql>
 <CAFCRh-9Le3fkJMWGuHdFPP-kfHdEAAchFZf0msEq3hNijixbFw@mail.gmail.com>
Subject: Re: Fwd: A million users
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_179035_1737198406.1731501713297"
Importance: Medium
User-Agent: Zoho Mail
Archived-At: <https://www.postgresql.org/message-id/193258b6791.ada07c1761341.959628411447004614%40jasonic.dk>
Precedence: bulk

------=_Part_179035_1737198406.1731501713297
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit

Hi Dominique 


Hi. Sure, that's a good point, and a best practice IMHO.
But I already do that, and the original question remain,
i.e. how does PostgreSQL with thousands or millions of roles?


Sorry if my original post was unclear, but I don't expect that there will be much more than perhaps a hundred roles. Each may have from a few up to a million users in them, though.


/kaare
------=_Part_179035_1737198406.1731501713297
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta content="text/html;charset=UTF-8" http-equiv="Content-Type"></head><body ><div style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10pt;"><div class="x_266308025moz-cite-prefix">Hi Dominique <br></div><br><div class="x_266308025moz-cite-prefix"><span style="white-space: pre-wrap"></span><br></div><blockquote><pre class="x_266308025moz-quote-pre">Hi. Sure, that's a good point, and a best practice IMHO.
But I already do that, and the original question remain,
i.e. how does PostgreSQL with thousands or millions of roles?
<br></pre></blockquote><br><div class="x_266308025moz-cite-prefix"><span style="white-space: pre-wrap">Sorry if my original post was unclear, but I don't expect that there will be much more than perhaps a hundred roles. Each may have from a few up to a million users in them, though.</span><br></div><div class="x_266308025moz-cite-prefix"><span style="white-space: pre-wrap"></span><br></div>/kaare<br></div><br></body></html>
------=_Part_179035_1737198406.1731501713297--