ĭue to limited time, some of the questions were not answered during the live webinar so answers by the host are provided below: Those who weren’t able to attend the live webinar can now view the recording here. We also explored how to exploit the catalog, how to send the information to other monitoring tools, and how the tables in pg_catalog are fundamentally interconnected to other matters such as performance, replication, MVCC, security, etc. This webinar reviewed the possibilities offered by the PostgreSQL catalog. To explore these features and more, 2ndQuadrant held a live webinar titled “ pg_catalog Unveiled! ”, hosted by Boriss Mejías (PostgreSQL Consultant at 2ndQuadrant). Standard monitoring tools are available to monitor the CPU, RAM, and I/O consumption, but they won’t be able to tell you if indexes are being used, if tables are bloated, if there is a lag of replication or a variety of other interesting and useful things within the PostgreSQL environment. PostgreSQL users are always interested in their system’s performance to know if any improvements need to be made or to generate the occasional health report requested by their managers. PostgreSQL 9 Cookbook – Chinese Edition.PostgreSQL Server Programming Cookbook – 2nd Edition.
PostgreSQL 9 Administration Cookbook – 3rd Edition.PostgreSQL High Availability Cookbook – 2nd Edition.
0 kommentar(er)
