Re: What to do with a PAAS-pg server - Mailing list pgsql-general

On Wed, Oct 30, 2024 at 11:49:29AM -0400, Ron Johnson wrote:
> Settings, like "SELECT * FROM pg_settings;"

This query will show you the non-default settings:

    SELECT name, current_setting(name), source
    FROM pg_settings
    WHERE source NOT IN ('default', 'override');

---------------------------------------------------------------------------

> On Wed, Oct 30, 2024 at 11:32 AM alexander al (leiden) <alexander@scred.nl>
> wrote:
> 
>     Hi,
> 
>     we have a supplier (via our client) who has an self build PAAS-version
>     of postgresql. Ok, you would say, that's fine. But, there is always an
>     but, we think the settings are not quite ok. We really want to know how
>     much memory etc there is on that server. So we can recommend the
>     recommended settings. Is there a way to get those information on the
>     server itself from psql?
> 
>     regards,
> 
>     Alexander Al
> 
> 
> 
> 
> 
> 
> 
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> crustacean!

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  When a patient asks the doctor, "Am I going to die?", he means 
  "Am I going to die soon?"