Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tB787-001w2Q-7h
	for pgsql-general@arkaria.postgresql.org; Wed, 13 Nov 2024 06:45:31 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tB784-00Bhop-Gt
	for pgsql-general@arkaria.postgresql.org; Wed, 13 Nov 2024 06:45:29 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <kaare@jasonic.dk>)
	id 1tB784-00Bhog-2S
	for pgsql-general@lists.postgresql.org; Wed, 13 Nov 2024 06:45:28 +0000
Received: from sender-op-o11.zoho.eu ([136.143.169.11])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <kaare@jasonic.dk>)
	id 1tB780-001ciB-RQ
	for pgsql-general@postgresql.org; Wed, 13 Nov 2024 06:45:27 +0000
ARC-Seal: i=1; a=rsa-sha256; t=1731480320; cv=none; 
	d=zohomail.eu; s=zohoarc; 
	b=AuGnfjJTyB3+wwlJeLj9XWHOLgfC7A+NgzTpZP8qLvlNI4WA+ZusrZr2iN4QDpZ0q2P+HhXWBE2LPZjQXTLfby+V5wj+3Clx+SomnSwElWlW4YyaaefXPpK30tkWQXFL7emFO/H2jmtGCBg+ADJXieaH7+00yOdoqeKK87uRkoc=
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=zohomail.eu; s=zohoarc; 
	t=1731480320; h=Content-Type:Content-Transfer-Encoding:Date:Date:From:From:MIME-Version:Message-ID:Subject:Subject:To:To:Message-Id:Reply-To:Cc; 
	bh=/gNXjxA67jgIRw39GKNMAPRPARS5Zn2bhbUtPWifw64=; 
	b=ZHrIbryVsUCMwRpTebTixB/FG9i0Fk07ZKYDH3AFX4pfLIQaocUhCON3VFYSnFM6tRZm06HSPThi3BhihZltoWDCVqCRuBMg7rbQ0sU7Okk24v8UUYSEBTe90aZg1Q0xotSrXhSstgPLuhXWLoBMxF1yQt1LxOmQhJiCTm6nJlk=
ARC-Authentication-Results: i=1; mx.zohomail.eu;
	dkim=pass  header.i=jasonic.dk;
	spf=pass  smtp.mailfrom=kaare@jasonic.dk;
	dmarc=pass header.from=<kaare@jasonic.dk>
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; t=1731480320;
	s=zmail; d=jasonic.dk; i=kaare@jasonic.dk;
	h=Date:Date:From:From:To:To:Message-ID:In-Reply-To:Subject:Subject:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-Id:Reply-To:Cc;
	bh=/gNXjxA67jgIRw39GKNMAPRPARS5Zn2bhbUtPWifw64=;
	b=pLqaMVo/7/B3ONlnhLr7mW7NfSuwN+PHzeiFq1yUGyU8xKgsMMER6ES+jTcId0YZ
	85JGvPEtxCdxCgFiTSxU6r41ySynOszVpWVumbLXzCMNRRV1IcvUCJbPFbarxrv8FAU
	opq70fZDrqnLcN+A8+8I+KcAqSKk78dzUJuZcuic=
Received: from mail.zoho.eu by mx.zoho.eu
	with SMTP id 1731480319457164.3390908094649; Wed, 13 Nov 2024 07:45:19 +0100 (CET)
Date: Wed, 13 Nov 2024 07:45:19 +0100
From: Kaare Rasmussen <kaare@jasonic.dk>
To: "pgsql-general" <pgsql-general@postgresql.org>
Message-ID: <1932444f587.1098347f3276523.6403251539793861793@jasonic.dk>
In-Reply-To: 
Subject: A million users
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 7bit
Importance: Medium
User-Agent: Zoho Mail
X-Mailer: Zoho Mail
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/1932444f587.1098347f3276523.6403251539793861793%40jasonic.dk>
Precedence: bulk

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.

Roles would be used to allow or restrict access to tables or rows 
according to the business rules.

/kaare