Re: Fwd: A million users - Mailing list pgsql-general

From Vijaykumar Jain
Subject Re: Fwd: A million users
Date
Msg-id CAM+6J97dYumtR2P+J6OdiLcAUqKGV0K3Nm3n=gZ5z+PMwYYhAg@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: A million users  (Achilleas Mantzios - cloud <a.mantzios@cloud.gatewaynet.com>)
Responses Re: Fwd: A million users
List pgsql-general


On Wed, Nov 13, 2024, 4:42 PM 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.


pgsql-general by date:

Previous
From: Achilleas Mantzios - cloud
Date:
Subject: Re: Fwd: A million users
Next
From: Vijaykumar Jain
Date:
Subject: Re: Fwd: A million users