public inbox for [email protected]  
help / color / mirror / Atom feed
From: Bruce Momjian <[email protected]>
To: Ron Johnson <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: What to do with a PAAS-pg server
Date: Thu, 31 Oct 2024 23:42:16 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CANzqJaAJxW_QdAQQe0poS2vq61LrKO7D8ZMg5RqcXsWQPoeBSg@mail.gmail.com>
References: <[email protected]>
	<CANzqJaAJxW_QdAQQe0poS2vq61LrKO7D8ZMg5RqcXsWQPoeBSg@mail.gmail.com>

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) <[email protected]>
> 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  <[email protected]>        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?"






view thread (4+ 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]
  Subject: Re: What to do with a PAAS-pg server
  In-Reply-To: <[email protected]>

* 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