public inbox for [email protected]  

help / color / mirror / Atom feed

From: Vijaykumar Jain <[email protected]>
To: Achilleas Mantzios - cloud <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Fwd: A million users
Date: Wed, 13 Nov 2024 17:10:26 +0530
Message-ID: <CAM+6J94wQNyUVN_1OEpHLwo2R4PQFpLeBNf=ndNG2AAfTGMoig@mail.gmail.com> (raw)
In-Reply-To: <CAM+6J97dYumtR2P+J6OdiLcAUqKGV0K3Nm3n=gZ5z+PMwYYhAg@mail.gmail.com>
References: <[email protected]>
	<[email protected]>
	<CAM+6J97dYumtR2P+J6OdiLcAUqKGV0K3Nm3n=gZ5z+PMwYYhAg@mail.gmail.com>

On Wed, Nov 13, 2024, 5:00 PM Vijaykumar Jain <
[email protected]> wrote:

>
>
> On Wed, Nov 13, 2024, 4:42 PM Achilleas Mantzios - cloud <
> [email protected]> 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.
>

https://fluca1978.github.io/2018/01/04/PostgreSQLUsers.html

so roles are not the problem.
but if you grant them individually select on the same table for ex. then
the limits are breached based of size of the col not number of permissions.

>
>

view thread (9+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Fwd: A million users
  In-Reply-To: <CAM+6J94wQNyUVN_1OEpHLwo2R4PQFpLeBNf=ndNG2AAfTGMoig@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox