Re: Understaning postgresql instance vs database

2021-08-14 Thread Adrian Klaver
On 8/14/21 10:34 AM, Open _ wrote: 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 port

Understaning postgresql instance vs database

2021-08-14 Thread Open _
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 l