Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1t6iYJ-00F33U-Vw
	for pgsql-general@arkaria.postgresql.org; Fri, 01 Nov 2024 03:42:23 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1t6iYH-008lVF-Gp
	for pgsql-general@arkaria.postgresql.org; Fri, 01 Nov 2024 03:42:21 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <bruce@momjian.us>)
	id 1t6iYH-008lV5-67
	for pgsql-general@lists.postgresql.org; Fri, 01 Nov 2024 03:42:21 +0000
Received: from momjian.us ([72.94.173.45])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <bruce@momjian.us>)
	id 1t6iYD-003tIu-SA
	for pgsql-general@postgresql.org; Fri, 01 Nov 2024 03:42:19 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us;
	s=2024011501; h=In-Reply-To:Content-Transfer-Encoding:Content-Type:
	MIME-Version:References:Message-ID:Subject:Cc:To:From:Date:Sender:Reply-To:
	Content-ID:Content-Description;
	bh=qpZFQLe1MG4t9DOl7f/8yPFis8JFg/6C01Y2bZZCkWI=; b=QrmYykBSoT7LFBiPoGn1TQrFaK
	qXhTBTLZ82LNdciDdMCef4YuKSRAGXuucrg0L8aAuO7ykbmh+PuZCAjh47fT+hepFGb1pwrNJL5+G
	1Z4mT0eRR7DZ3foGVVbYZ5g0gyDKR3Me9nxNzE+O+k6E//Udriv2Gorp35bryil7QxM/X11buPEij
	bLYpXElRXdth5NWBdmhQIAmTRziou2NH1aO4uryJAI4PQqkAwXf5g10Dw6XSms6zzAra2tN0Hf9+5
	CVN4fMd7jiJt84GCMubANLZ7RJ4221Sv1y/poIwGI1nOO6tTYE/UoLC8fyvqIxLutiQefQAvyK9BJ
	Pw0hif3g==;
Received: from bruce by momjian.us with local (Exim 4.96)
	(envelope-from <bruce@momjian.us>)
	id 1t6iYC-004S06-33;
	Thu, 31 Oct 2024 23:42:16 -0400
Date: Thu, 31 Oct 2024 23:42:16 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: What to do with a PAAS-pg server
Message-ID: <ZyROGAcZB3LKUMwi@momjian.us>
References: <aac85bb09a0cb27eb88075d1f6988e3fb7d3483f.camel@scred.nl>
 <CANzqJaAJxW_QdAQQe0poS2vq61LrKO7D8ZMg5RqcXsWQPoeBSg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <CANzqJaAJxW_QdAQQe0poS2vq61LrKO7D8ZMg5RqcXsWQPoeBSg@mail.gmail.com>
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/ZyROGAcZB3LKUMwi%40momjian.us>
Precedence: bulk

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?"