pg_proctab is a collection of PostgreSQL stored functions that provide access to the operating system process table using SQL. We'll show you which functions are available and where they collect the data, and give examples of their use to collect processor and I/O statistics on SQL queries. These stored functions currently only work on Linux-based systems.
Data volumes are growing rapidly, and it's not always feasible to store the data and then query it quickly enough to act on the results. Streaming Database Systems are the solution that will scale to these huge data volumes without sacrificing arbitrary queries or the power of SQL.
This talk introduces pgTAP, a library of PL/pgSQL functions for unit testing your database. Got custom functions you need to test? Triggers? New data types, enums, or domains? This is the test suite for you!
While our perceptions of reality are defined in terms of entities and their associated relationships, often we has humans tend to view our reality in terms of classifications. Incorporating hierarchical modeling into our modelling toolkit gives us additional ways to model data as we naturally perceive it.