public inbox for [email protected]help / color / mirror / Atom feed
What to do with a PAAS-pg server 4+ messages / 4 participants [nested] [flat]
* What to do with a PAAS-pg server @ 2024-10-30 15:32 alexander al (leiden) <[email protected]> 2024-10-30 15:49 ` Re: What to do with a PAAS-pg server Ron Johnson <[email protected]> 2024-11-01 06:07 ` Re: What to do with a PAAS-pg server Ian Lawrence Barwick <[email protected]> 0 siblings, 2 replies; 4+ messages in thread From: alexander al (leiden) @ 2024-10-30 15:32 UTC (permalink / raw) To: pgsql-general 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: What to do with a PAAS-pg server 2024-10-30 15:32 What to do with a PAAS-pg server alexander al (leiden) <[email protected]> @ 2024-10-30 15:49 ` Ron Johnson <[email protected]> 2024-11-01 03:42 ` Re: What to do with a PAAS-pg server Bruce Momjian <[email protected]> 1 sibling, 1 reply; 4+ messages in thread From: Ron Johnson @ 2024-10-30 15:49 UTC (permalink / raw) To: pgsql-general Settings, like "SELECT * FROM pg_settings;" 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! ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: What to do with a PAAS-pg server 2024-10-30 15:32 What to do with a PAAS-pg server alexander al (leiden) <[email protected]> 2024-10-30 15:49 ` Re: What to do with a PAAS-pg server Ron Johnson <[email protected]> @ 2024-11-01 03:42 ` Bruce Momjian <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Bruce Momjian @ 2024-11-01 03:42 UTC (permalink / raw) To: Ron Johnson <[email protected]>; +Cc: 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) <[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?" ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: What to do with a PAAS-pg server 2024-10-30 15:32 What to do with a PAAS-pg server alexander al (leiden) <[email protected]> @ 2024-11-01 06:07 ` Ian Lawrence Barwick <[email protected]> 1 sibling, 0 replies; 4+ messages in thread From: Ian Lawrence Barwick @ 2024-11-01 06:07 UTC (permalink / raw) To: alexander al (leiden) <[email protected]>; +Cc: pgsql-general 2024年10月31日(木) 0:32 alexander al (leiden) <[email protected]>: > > 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? If you mean you e.g. only have access to psql on the server in question, but want to know more about the server itself (i.e. not the PostgreSQL settings), then you might have luck poking around with the pg_read_file() function, e.g.: SELECT pg_read_file('/proc/meminfo'); Note you will need database superuser permission to execute pg_read_file(), or for non-superusers be granted EXECUTE permission on it. Regards Ian Barwick ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-11-01 06:07 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-10-30 15:32 What to do with a PAAS-pg server alexander al (leiden) <[email protected]> 2024-10-30 15:49 ` Ron Johnson <[email protected]> 2024-11-01 03:42 ` Bruce Momjian <[email protected]> 2024-11-01 06:07 ` Ian Lawrence Barwick <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox