Re: Users, Roles and Connection Pooling

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: Matt Andrews <mattandrews(at)massey(dot)com(dot)au>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Users, Roles and Connection Pooling
Date: 2019-10-02 07:43:10
Message-ID: 20191002074310.GH6962@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

* Laurenz Albe (laurenz(dot)albe(at)cybertec(dot)at) wrote:
> A couple of pointers:

I generally agree with these comments.

> - This is a good setup if you don't have too many users. Metadata
> queries will start getting slow if you get into the tens of thousands
> of users, maybe earlier.

While this seems plausible- I'd love to hear about exactly what you've
seen start to be a problem when getting up to that many users. Are you
just referring to things like \du? Or..?

Thanks,

Stephen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matt Andrews 2019-10-02 09:41:13 Re: Users, Roles and Connection Pooling
Previous Message Laurenz Albe 2019-10-02 07:36:53 Re: Users, Roles and Connection Pooling