Understaning postgresql instance vs database

From: Open _ <opensheart(at)yahoo(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Understaning postgresql instance vs database
Date: 2021-08-14 17:34:31
Message-ID: 758931831.343916.1628962471940@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In Informix, the instance is everything.   Buffer pools, transaction logging, backup and restores and all monitoring is done at the instance level
databases are just logical collections of tables in an instance.
In DB2 there is some instance configuration, but most everything is at the database level.   Buffer pools, logging, backups and restores are done at the database level.   Process load monitoring might be done at the instance level with db2top.
It seems like Postgres is like DB2, there are some things at the instance level and some at the database level.
But I'm having a hard time sorting out what is where.
Like what in PostgreSQL's statistics collector is an instance statistic verses a database statistic. 

I found a pgtop utility but it seems to require a database parameter
So are all stats database specific?or is the top info instance stats and the list portion database specific?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2021-08-14 17:41:28 Re: Understaning postgresql instance vs database
Previous Message bret_stern@machinemanagement.com 2021-08-14 17:32:24 Re: Sort question - Fractions, Metric etc