Re: What to do with a PAAS-pg server

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(at)scred(dot)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(at)momjian(dot)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?"