MIME-Version: 1.0
References: <202411131029.qchduffwgzhm@alvherre.pgsql> <3a93d9b1-e2a1-4d33-b9fc-702b8d43cdba@cloud.gatewaynet.com>
In-Reply-To: <3a93d9b1-e2a1-4d33-b9fc-702b8d43cdba@cloud.gatewaynet.com>
From: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Date: Wed, 13 Nov 2024 17:00:26 +0530
Message-ID: <CAM+6J97dYumtR2P+J6OdiLcAUqKGV0K3Nm3n=gZ5z+PMwYYhAg@mail.gmail.com>
Subject: Re: Fwd: A million users
To: Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005b58dc0626c9ab4e"
Archived-At: <https://www.postgresql.org/message-id/CAM%2B6J97dYumtR2P%2BJ6OdiLcAUqKGV0K3Nm3n%3DgZ5z%2BPMwYYhAg%40mail.gmail.com>
Precedence: bulk

--0000000000005b58dc0626c9ab4e
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Nov 13, 2024, 4:42=E2=80=AFPM Achilleas Mantzios - cloud <
a.mantzios@cloud.gatewaynet.com> wrote:

>
> Exactly! In the later versions, security gets more and more refined and
> strengthened. So ppl should think about moving away from "public" , and
> start implementing finer grained schemes of security, as you suggest. +
> \dp shows prettier than having 1000+ users listed.
>

I wanted to just communicate the limits.
a lot of postgresql architecture can leverage the resources and scale, but
not all.
i had 100s of 1000s of tables on my setup where i worked last.
if i did \dt it would freeze all the time. i had to exit the pdwl session,
check the source code of how the partition was named and then look for what
I wanted.
if things are pretty with psql or not should not be a criteria for how many
objects you want to have.

i would expect clear exceptions  so one knows what the real problem is.
the error I got did not in anyway communicate the role limits for col size
limits.

--0000000000005b58dc0626c9ab4e
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">On Wed, Nov 13, 2024, 4:42=E2=80=AFPM Achilleas Mantzi=
os - cloud &lt;<a href=3D"mailto:a.mantzios@cloud.gatewaynet.com">a.mantzio=
s@cloud.gatewaynet.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_q=
uote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1e=
x"><br>
Exactly! In the later versions, security gets more and more refined and <br=
>
strengthened. So ppl should think about moving away from &quot;public&quot;=
 , and <br>
start implementing finer grained schemes of security, as you suggest. + <br=
>
\dp shows prettier than having 1000+ users listed.<br></blockquote></div></=
div><div dir=3D"auto"><br></div><div dir=3D"auto">I wanted to just communic=
ate the limits.</div><div dir=3D"auto">a lot of postgresql architecture can=
 leverage the resources and scale, but not all.</div><div dir=3D"auto">i ha=
d 100s of 1000s of tables on my setup where i worked last.</div><div dir=3D=
"auto">if i did \dt it would freeze all the time. i had to exit the pdwl se=
ssion, check the source code of how the partition was named and then look f=
or what I wanted.</div><div dir=3D"auto">if things are pretty with psql or =
not should not be a criteria for how many objects you want to have.</div><d=
iv dir=3D"auto"><br></div><div dir=3D"auto">i would expect clear exceptions=
=C2=A0 so one knows what the real problem is.</div><div dir=3D"auto">the er=
ror I got did not in anyway communicate the role limits for col size limits=
.</div><div dir=3D"auto"><br></div><div dir=3D"auto"><br></div><div dir=3D"=
auto"><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D=
"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
</blockquote></div></div></div>

--0000000000005b58dc0626c9ab4e--