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