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:00:26 +0530
Message-ID: <CAM+6J97dYumtR2P+J6OdiLcAUqKGV0K3Nm3n=gZ5z+PMwYYhAg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

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.

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+6J97dYumtR2P+J6OdiLcAUqKGV0K3Nm3n=gZ5z+PMwYYhAg@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