Date: Fri, 22 Nov 2024 07:20:20 +0100
From: Kaare Rasmussen <kaare@jasonic.dk>
To: "Alvaro Herrera" <alvherre@alvh.no-ip.org>
Cc: "Dominique Devienne" <ddevienne@gmail.com>,
	"Vijaykumar Jain" <vijaykumarjain.github@gmail.com>,
	"pgsql-general" <pgsql-general@postgresql.org>
Message-Id: <1935287538c.12320a527291389.7229223853382999474@jasonic.dk>
In-Reply-To: <202411131340.63qb3y2wsinb@alvherre.pgsql>
References: <202411131340.63qb3y2wsinb@alvherre.pgsql>
Subject: Re: Fwd: A million users
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_768501_2035540047.1732256420748"
Importance: Medium
User-Agent: Zoho Mail
Archived-At: <https://www.postgresql.org/message-id/1935287538c.12320a527291389.7229223853382999474%40jasonic.dk>
Precedence: bulk

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

Hi  That said, having a million users is a bit strange.  Do you want to give
each visitor to your website a unique Postgres role, or something like
that?  I think this is unusual, but it should work.


OK, thanks for the feedback, all. It may not be necessary to have
      such a fine grained system, but I was just wondering.


the caches used to store contents of system catalogs.  I think you
should test it out and see what happens.  I haven't seen any published
_actual_ benchmarks on this point.


I will, if this progresses. I did want to know if something like
      this has been tried and failed before.

/kaare
------=_Part_768501_2035540047.1732256420748
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;">Hi<span style="white-space: pre-wrap"> </span> <blockquote><pre class="x_73069579moz-quote-pre">That said, having a million users is a bit strange.  Do you want to give
each visitor to your website a unique Postgres role, or something like
that?  I think this is unusual, but it should work.
<br></pre></blockquote><p>OK, thanks for the feedback, all. It may not be necessary to have
      such a fine grained system, but I was just wondering.<br></p><p><span style="white-space: pre-wrap"></span><br></p><blockquote><pre class="x_73069579moz-quote-pre">the caches used to store contents of system catalogs.  I think you
should test it out and see what happens.  I haven't seen any published
_actual_ benchmarks on this point.<br></pre></blockquote><p>I will, if this progresses. I did want to know if something like
      this has been tried and failed before.<br></p><p>/kaare<br></p><p><br></p></div><br></body></html>
------=_Part_768501_2035540047.1732256420748--