PGCon2009 - Final Release

PGCon 2009
The PostgreSQL Conference

Chris Browne
Day Talks - second day - 2009-05-22
Room DMS 1110
Start time 13:30
Duration 01:00
ID 151
Event type Lecture
Track Advanced Features
Language used for presentation English

PostgreSQL and Temporal Data

PostgreSQL has had support for storage of temporal data, including a "time travel" capability, since even before it was called PostgreSQL, and PostgreSQL offers a fairly good set of operators to work on temporal data, at least when comparing with SQL standards.

This talk describes several of the ways that PostgreSQL may be used to record temporal data, along with advantages and disadvantages.

This talk will discuss:

  • What sorts of functionality "base" PostgreSQL offers;

  • What temporal functionality is added by the PGTemporal project (e.g. - the "period" type, comprising (from/to))

  • Additional functionality that would be desirable (e.g. - temporally-aware foreign keys)

  • Other useful representations of temporality, and their usage:

  • Pointers to transactions
  • Serial Number temporality