1. 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.

    # vimeo.com/7173577 Uploaded 112 Plays / / 0 Comments Watch in Couch Mode
  2. 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.

    # vimeo.com/4793886 Uploaded 194 Plays / / 0 Comments Watch in Couch Mode
  3. 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!

    # vimeo.com/4789696 Uploaded 236 Plays / / 0 Comments Watch in Couch Mode
  4. Mark Wong and Pg Top at West 08 (postgresqlconference.org/)

    # vimeo.com/4595351 Uploaded 100 Plays / / 0 Comments Watch in Couch Mode
  5. A talk given at West08 (postgresqlconference.org/) by PgUS Board Member Richard Broersma Jr.

    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.

    # vimeo.com/4594336 Uploaded 147 Plays / / 0 Comments Watch in Couch Mode


Joshua Drake Plus

Dedicated to the World's Most Advanced Open Source Database.

Browse This Channel

Shout Box

  • Alonso Garcia

    Im new to vimeo, but the presentation "SQLAlchemy and PostgreSQL" doesnt show 90 minutes, i think it lasts only 2 or 3!

    by Alonso Garcia

Channels are a simple, beautiful way to showcase and watch videos. Browse more Channels. Channels