FOSSLC is a non-profit organization that specializes in technology and know-how to record conferences with excellent quality. Click on the icons below to view great videos from communities we are actively involved with:

 

PostgreSQL

Content related to the PostgreSQL RDBMS.

PostgreSQL in Mission-Critical Financial Systems

in PGCon, PGCon2010, Programming, PostgreSQL
PostgreSQL

Location

Ottawa, ON
Canada
45° 24' 41.6592" N, 75° 41' 53.4984" W

Case study of PostgreSQL in the Multicanal project of the brazilian bank Caixa Economica Federal

Case study of PostgreSQL in the project "Multicanal" of the brazilian government bank Caixa Economica Federal - the day-to-day activities, challenges, solutions proposed and approved, high availability and high performance in the world's unique Free Software case in this type of public institution.

Introduction to the "Multicanal" project, how it works, what it does and the importance for Caixa and the brazilian people. The inclusion of PostgreSQL and other Free and Open-Source Software on the project and Caixa at all. The role of 4Linux and Caixa in the project. Day-to-day challenges in the database administration. Database production and maintenance challenges. PostgreSQL tuning techniques involved in the systems. Tested and approved high availability techniques for PostgreSQL. Today's and future needs. Planned and achieved objectives.

Event: 
Summercamp2010
Speaker: 
Flavio Gurgel

Built-in replication in PostgreSQL 9.0

in PGCon, PGCon2010, Programming, PostgreSQL
PostgreSQL

Location

Ottawa, ON
Canada
45° 24' 41.6592" N, 75° 41' 53.4984" W

An introduction to the new built-in replication features in PostgreSQL 9.0, Hot Standby and Streaming Replication.

A quick walk-through of setting up a hot standby server with streaming replication, and the options available to control it. Discussion on various trade-offs and pitfalls with Hot Standby.

Event: 
PGCon2009
Speaker: 
Heikki Linnakangas

Not Just UNIQUE

in PGCon, PGCon2010, Programming, PostgreSQL
PostgreSQL

Location

Ottawa, ON
Canada
45° 24' 41.6592" N, 75° 41' 53.4984" W

UNIQUE is no longer unique among constraints. I authored "Exclusion Constraints" for PostgreSQL 8.5: a more general constraint mechanism that can enforce constraints such as "non-overlapping" as well as unique; and can enforce constraints on GiST or hash indexes as well as BTree. See why other constraint mechanisms are unsuitable for common business requirements -- like handling schedule conflicts -- and how the problems are solved by using Exclusion Constraints.

Exclusion Constraints are a more general constraint enforcement mechanism than UNIQUE; new in PostgreSQL 8.5. The constraints specify the conditions under which two tuples conflict, and concurrent updates are resolved with the same semantics as UNIQUE.

The existing UNIQUE constraints are a special case of Exclusion Constraints in which the two tuples conflict if all columns in the constraint are equal. Exclusion Constraints allow other operators to be specified. For instance, a reservation system may require that two tuples conflict if the room numbers are equal and the reservation periods overlap (as part of the demonstration, I make use of a user-defined PERIOD data type). Any operator can be specified as long as it is binary, boolean, commutative, and there's an operator class for the required index search (which is used to check for conflicts, much like the existing UNIQUE constraint mechanism).

Exclusion Constraints are important because they are easy, scalable, flexible and general to many different business needs. See why alternatives and workarounds all have serious problems and limitations, and how they are solved by using Exclusion Constraints.

Event: 
PGCon2010
Speaker: 
Jeff Davis

Postgres for non-Postgres people

in Community, PGCon, PGCon2010, Programming, PostgreSQL
PostgreSQL

Location

Ottawa, ON
Canada
45° 24' 41.6592" N, 75° 41' 53.4984" W

Getting to know the Postgres way

Experience in one database system does not always make learning another one easy. Although Postgres is more SQL-compliant than just about anything else, there are plenty of quirks, features, and gotchas that you should be aware of.

Postgres has an active and thriving community. We'll explore what makes the project unique, from developer philosophy to SQL features to advocacy, and everything in between. If you are coming from another database system, this will get you up to speed on the important differences between Postgres and everything else.

Event: 
PGCon2010
Speaker: 
Greg Sabino Mullane