public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Alerting on memory use and instance crash
Date: Wed, 8 Oct 2025 15:06:58 -0400
Message-ID: <CANzqJaCpM18oHAYpZHk9cW=0zjxMGKLKZOPCi1eHGm4ssb4ZsA@mail.gmail.com> (raw)
In-Reply-To: <CAD=mzVVBHZ6480qrbPYhvpkkKqGeBpahV-+=r0xXU7O0XXQ5zw@mail.gmail.com>
References: <CAD=mzVXjx-ULCM-ZdSz2RDSoL8EA1Bsd+0gBxgOCTWV_tC4GDw@mail.gmail.com>
<[email protected]>
<CAD=mzVVBHZ6480qrbPYhvpkkKqGeBpahV-+=r0xXU7O0XXQ5zw@mail.gmail.com>
On Wed, Oct 8, 2025 at 2:58 PM sud <[email protected]> wrote:
[snip]
> Do you mean in normal Postgres it's alway a single instance/memory and
> single storage attached? then I also do not see any such cluster level
> views in aws aurora postgres too?
>
Yup.
> Pardon if it's a silly one to ask.
>
A Google for "what's the difference between Oracle and Postgresql" _might_
help. I've never done that, so don't know what you'll find.
As far as how Aurora works... you need to ask AWS. It's been too heavily
modified for a list dedicated to pure/unmodified Postgresql to help.
> On Wed, Oct 8, 2025 at 9:52 PM Adrian Klaver <[email protected]>
> wrote:
>
>> On 10/8/25 08:42, sud wrote:
>> > Hi Experts,
>> >
>> > It's postgres version 16. I have two questions on alerting as below.
>> >
>> > 1)If we want to have alerting on any node/instance that gets crashed :-
>> > In other databases like Oracle the catalog Views like "GV$Instance"
>> used
>> > to give information on whether the instances are currently active/down
>> > or not. But in postgres it seems all the pg_* views are instance
>> > specific and are not showing information on the global/cluster level
>> but
>> > are restricted to instance level only. So is there any other way to
>> > query the pg_* views to have alerts on the specific instance crash?
>>
>> 1) When you say instance do you mean database?
>>
>> 2) Not all system tables/views are database only.
>>
>> For instance:
>> https://www.postgresql.org/docs/current/catalog-pg-database.html
>> https://www.postgresql.org/docs/current/catalog-pg-auth-members.html
>> https://www.postgresql.org/docs/current/catalog-pg-authid.html
>> https://www.postgresql.org/docs/current/view-pg-roles.html
>>
>>
>> > 2)Is there a way to fetch the data from pg_* view to highlight the
>> > specific connection/session/sqls which is using high memory in postgres?
>> >
>> > Appreciate your guidance.
>> >
>> > Regards
>> > Sud
>>
>>
>> --
>> Adrian Klaver
>> [email protected]
>>
>
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
view thread (11+ 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: Alerting on memory use and instance crash
In-Reply-To: <CANzqJaCpM18oHAYpZHk9cW=0zjxMGKLKZOPCi1eHGm4ssb4ZsA@mail.gmail.com>
* 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