BEGIN:VCALENDAR
CALSCALE:GREGORIAN
PRODID:-//Pentabarf//Schedule//EN
VERSION:2.0
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Hi\, I'm David. I like to write database apps. Just as much as 
 I like to write web apps. (Maybe more!) How? Not by relying on bolted-on\, 
 half-baked database integration tools like migrations\, I'll tell you that!
 . Instead\, I make extensive use of best-of-breed tools for source control 
 ([Git](http://git-scm.org/)\, database unit testing ([pgTAP](http://pgtap.o
 rg/))\, and database change management and deployment ([Sqitch](http://sqit
 ch.org/)). If you'd like to get as much pleasure out of database developmen
 t as you do application development\, join me for this tutorial. We'll deve
 lop a sample application using the processes and tools I've come to depend 
 on\, and you'll find out whether they might work for you. Either way\, I pr
 omise it will at least be an amusing use of your time.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130522T130000
DURATION:PT3H00M
LOCATION:MRT 256
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Agile Database Development - with Git\, Sqitch\, and pgTAP
UID:615@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/615.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Amazon Web Services provides tremendous tools and techniques fo
 r scaling services up and down in response to planned or experienced load. 
 However\, too many systems are configured to use AWS as an equipment-rental
  facility\, which wastes money and does not take advantage of AWS' unique p
 roperties. We'll talk about how to build systems that flex-scale using AWS 
 tools.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T163000
DURATION:PT1H00M
LOCATION:MRT 256
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Automated PostgreSQL Scaling on AWS - Managing Your Thundering Herd
UID:535@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/535.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:The Traditional Closing Session
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T173000
DURATION:PT1H00M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Closing sessions - prizes\, auctions\, fun\, games
UID:623@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/623.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:This will not be the most exciting talk\, nor is there (current
 ly) a simple answer to make hardware corruption problems go away. But it's 
 important -- without being careful\, it's easy for corruption to spread to 
 replicas and backups\, leaving data hopelessly lost. Or\, a strange crash d
 ue to corruption could take many engineering resources to analyze.This talk
  is about kinds of hardware corruption that can and do happen\, and the way
 s to detect and contain the corruption as quickly as possible. Additionally
 \, we'll discuss a roadmap of improvements to postgresql to make this an ea
 sier process\; as well as alternatives (such as detecting corruption in the
  filesystem).Note: Some storage systems do provide strong protections again
 st data corruption. This talk is primarily (though not exclusively) targete
 d at users of the local filesystem\, particularly on Linux.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T113000
DURATION:PT1H00M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Corruption Detection and Containment - Strategies and Roadmap
UID:586@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/586.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:This talk is best for those who are are familiar with databases
  and SQL\, but want to learn how to move processing from their applications
  into the database to improve consistency\, administration\, and performanc
 e.  Topics covered  include advanced SQL features like referential integrit
 y constraints\, ANSI joins\, views\, rules\, and triggers.  The presentatio
 n also explains how to create server-side functions\, operators\, and custo
 m data types in PostgreSQL.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130521T090000
DURATION:PT3H00M
LOCATION:MRT 256
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Data Processing Inside PostgreSQL
UID:607@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/607.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Puppet is a platform for I.T. automation and configuration mana
 gement that has gained popularity in the devops movement.  This talk will p
 rovide an introduction to puppet and talk about how Afilias uses puppet to 
 deploy and maintain over one hundred servers running PostgreSQL that suppor
 t key parts of the DNS infrastructure
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T113000
DURATION:PT1H00M
LOCATION:MRT 256
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Elephant Puppets - Deployment automation for PostgreSQL
UID:540@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/540.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Your query has been running for 70 hours. Should you kill it no
 w or ignore angry calls for a few more hours and hope it returns the result
 ?A question many a DBA have asked themselves. This talk will try to cover s
 ome of the techniques the database system could use in order to make decisi
 ons like that easier. We'll describe an approach based on existing research
  papers and report on the attempt of implementing it in a useful way inside
  PostgreSQL.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T150000
DURATION:PT1H00M
LOCATION:MRT 221
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Estimating query progress - Theory and practice of query progress i
 ndication
UID:576@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/576.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:A place to gather...
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T190000
DURATION:PT5H00M
LOCATION:L140
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Hacker Lounge - meet\, greet\, code\, slack
UID:624@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/624.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:A place to gather...
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130521T190000
DURATION:PT5H00M
LOCATION:L140
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Hacker Lounge - meet\, greet\, code\, slack
UID:636@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/636.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:A place to gather...
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T190000
DURATION:PT5H00M
LOCATION:L140
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Hacker Lounge - meet\, greet\, code\, slack
UID:618@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/618.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:A place to gather...
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130522T190000
DURATION:PT5H00M
LOCATION:L140
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Hacker Lounge - meet\, greet\, code\, slack
UID:622@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/622.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:We'll cover how to write your first patch to PG\, submit it for
  review\, and profit!
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T133000
DURATION:PT1H00M
LOCATION:MRT 221
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Hacking on PostgreSQL - Add your feature to PG!
UID:545@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/545.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:For a long time\, Postgres has been the best kept secret of sma
 rt DBAs. Lately\, it's become well-known that "all the cool kids" are using
  Postgres. In a recent Ruby on Rails community survey\, more developers pre
 ferred Postgres in production to MySQL\; Django's founder\, Jacob Kaplan-Mo
 ss\, has said given the option he'd only support Postgres. 
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T113000
DURATION:PT1H00M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:How Postgres Got Its Groove Back - How a 25 Year Old Database Becam
 e The Next Big Thing
UID:566@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/566.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:How to implement PostgreSQL in a demanding project\, what are t
 he different technical offerings good for? All you wanted to know about rep
 lication and never dared to ask.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T100000
DURATION:PT1H00M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Implementing High Availability - Availability\, Durability\, Archit
 ecture\, Replication... explained
UID:533@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/533.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:PostgreSQL Enterprise Consortium (PGEcons) is a non-profit orga
 nization aiming for promoting PostgreSQL in production use\, especially in 
 mission critical area. It is formed by leading IT companies in Japan last y
 ear. Currently PGECons has 36 company members. In the first fiscal year\, P
 GECons performed two major technical activities: PostgreSQL scale up/scale 
 out evaluation (by Working Group 1: WG1) and establishing migration process
  from commercial DBMSs to PostgreSQL (by Working Group 2: WG2). These objec
 tives were determined based on requests from PostgreSQL users and PGECons m
 embers and PGECons believes that sharing the experience is a big benefit fo
 r PostgreSQL community. In this talk we present current achievements of WG1
  and WG2. 
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T163000
DURATION:PT1H00M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Introducing PostgreSQL Enterprise Consortium activities
UID:556@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/556.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:A regular feature\, PGCon will have a Lightning talks session\,
  with presentations on diverse topics.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T161500
DURATION:PT1H00M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Lightning talks - Short sharp descriptions of short topics
UID:620@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/620.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:EnterpriseDB invites all PGCon attendees to a big evening with 
 drinks\, appetizers\, dinner and music on Thursday May 17th at [My Condo](h
 ttp://mycondoottawa.ca/)\, just minutes from the conference venue in the By
 ward Market. 
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T180000
DURATION:PT3H00M
LOCATION:Out and about
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Major Social Event! - sponsored by EnterpriseDB
UID:621@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/621.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:We have developed a versatile system to monitor machines and gr
 oups of machines. The system is well proven and used in industrial producti
 on\, power supply industry\, research and development. PostgreSQL is used t
 o store all the measurements and metadata. The system also containes some S
 CADA elements.This talk explains the database related essentials of the mon
 itoring part of the software.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T100000
DURATION:PT1H00M
LOCATION:MRT 256
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Monitoring of Machines using PostgreSQL
UID:548@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/548.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Nulls are a very useful but also very error-prone relational da
 tabase feature.  This talk is designed to help applications developers bett
 er manage their use of Nulls.  
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T113000
DURATION:PT1H00M
LOCATION:MRT 256
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Nulls Make Things Easier?
UID:608@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/608.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Logical Replication in the context of postgres to this date con
 sists out of several independent out-of-core solutions. While some of these
  solutions are great\, the existance of many of those also causes problems 
 like code duplication\, lack of trust\, features\, reliability and peforman
 ce.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T113000
DURATION:PT1H00M
LOCATION:MRT 221
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:On the road to in-core logical replication!? Part 1: Architecture o
 f Changeset Extraction
UID:577@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/577.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:We present a prototype of nested hstore data type with arrays s
 upport. We consider the new hstore as a step forward true json data type. 
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T163000
DURATION:PT1H00M
LOCATION:MRT 221
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:One step forward  true json data type. - Nested hstore with arrays 
 support.
UID:518@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/518.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Rumor has it all these other users and companies do this thing 
 called "backup" on their database. And people keep saying it's a good idea.
  But what does it actually mean?
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T133000
DURATION:PT1H00M
LOCATION:MRT 256
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:PostgreSQL Backup Strategies
UID:604@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/604.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:What's the great thing about a database?  Why\, it stores data 
 of course!  However\, one feature that makes a database useful is the diffe
 rent data types that can be stored in it\, and the breadth and sophisticati
 on of the data types in PostgreSQL is second-to-none\, including some novel
  data types that do not exist in any other type of database software!This t
 utorial will take an in-depth look at all of the native data types built ri
 ght into PostgreSQL as of version 9.2 (with some peeking ahead to 9.3).  We
  will take a look at the functionality provided with each data type\, examp
 les of how they are used both in theory and practice\, and  of course\, bes
 t practices that demonstrate the robustness of PostgreSQL.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130521T130000
DURATION:PT3H00M
LOCATION:MRT 256
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:PostgreSQL Datataypes - Datatypes like you never saw them before A 
 Whirlwind Tour of PostgreSQL Data Types
UID:633@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/633.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:The Corosync/Pacemaker framework which is part of the LinuxHA s
 tack can be used to provide monitoring and automatic failover capabilities.
  Now with streaming replication in place\, it makes sense to use this robus
 t infrastructure for PostgreSQL master and its replica handling. The open s
 ource pgsql resource agent also does this now. This talk will talk about us
 ing Corosync/Pacemaker with Postgres.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T113000
DURATION:PT1H00M
LOCATION:MRT 221
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:PostgreSQL High Availability with Corosync/Pacemaker
UID:546@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/546.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Apache Hadoop is an open-source framework that enables the cons
 truction of distributed\, data-intensive applications running on clusters o
 f commodity hardware. Building on a foundation initially composed of the Ma
 pReduce programming model and Hadoop Distributed Filesystem\, in recent yea
 rs Hadoop has expanded to include applications for data warehousing (Apache
  Hive)\, ETL (Apache Pig)\, and NoSQL column stores (Apache HBase). In this
  talk we describe recent work done at Citus Data that makes it possible to 
 run a distributed version of PostgreSQL on top of Hadoop in a manner that c
 ombines the rich feature set and low-latency responsiveness of PostgreSQL w
 ith the scalability and performance characteristics of Hadoop.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T150000
DURATION:PT1H00M
LOCATION:MRT 256
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:PostgreSQL on Hadoop - Bridging the Divide with Distributed Foreign
  Tables
UID:602@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/602.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:The ZFS filesystem can be used simplify a number of replication
 \, backup and recovery challenges. In this hands-on workshop\, an introduct
 ion to the ZFS file system's features and capabilities will be presented\, 
 then a walk through of common scenarios where ZFS can save considerable has
 sle and countless hours when users and/or developers go astray. A VM will b
 e provided for a hands-on experience.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130522T090000
DURATION:PT3H00M
LOCATION:MRT 256
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:PostgreSQL on ZFS - Replication\, Backup\, and Human Disaster Recov
 ery
UID:612@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/612.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Postgres 9.3 is still a few months out\, but we've already got 
 some interesting things to play with. Join us in this overview of new featu
 res coming in Postgres 9.3\, and see what goodies it has in store for you. 
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T100000
DURATION:PT1H00M
LOCATION:MRT 221
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Postgres Preview - A First Look At What's Coming In Postgres 9.3
UID:516@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/516.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Postgres at Disqus
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T090000
DURATION:PT0H45M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Postgres at Disqus - keynote - The present & the future
UID:619@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/619.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:This talk will discuss the problems which can occur when multip
 le database transactions are accessing the same data in PostgreSQL\, and th
 e various approaches to managing those problems.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T100000
DURATION:PT1H00M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:PostgresSQL Concurrency - How to manage race conditions in database
  access
UID:594@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/594.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:University of Alberta migrated their central Learning Managemen
 t System from Blackboard Vista on Oracle to Moodle on Postgresql 9.0 runnin
 g inside VMWare cluster. We went from a pilot project of 13 courses in Janu
 ary 2011 to  running all centrally supported courses (3600+) in Moodle in S
 eptember 2012. Our central Moodle instance has seen more than 500\,000 page
  loads and over 24\,000 unique visitors in a single day. Since then we depl
 oyed Postgresql in a number of mission critical applications including our 
 ticketing system and Enterprise Document Management system.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T100000
DURATION:PT1H00M
LOCATION:MRT 256
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Postgresql in Education - Lessons learned from deploying Postgresql
  at University of Alberta
UID:567@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/567.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:The PostgreSQL query planner does an excellent job with most qu
 eries\, but no query planner is perfect. 
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T150000
DURATION:PT1H00M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Query Planning Gone Wrong - An analysis of common query planner fai
 lure modes
UID:557@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/557.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Pick up your registration pack
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130522T150000
DURATION:PT4H00M
LOCATION:Royal Oak
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Registration pickup - The social way to register: at the pub
UID:617@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/617.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Row-level security has a feature with longstanding development.
  It can enforce users to reference or modify part of rows according to the 
 configured security policy. So\, we can utilize this feature as if virtual 
 private database on other commercial database\, however\, we designed this 
 feature much carefully to keep both of reliable security and minimum perfor
 mance trade-off. In addition\, we enhanced usability to allow row-level sec
 urity policy using usual expressions\, also plan to integration with label 
 based mandatory access control.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T150000
DURATION:PT1H00M
LOCATION:MRT 221
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Row Level Security
UID:571@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/571.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Performance tips and tricks on SQL level.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T150000
DURATION:PT1H00M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:SQL hints\, tips\, tricks and tuning
UID:561@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/561.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:How to integrate both tools and obtain the best performance + r
 eliability.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T133000
DURATION:PT1H00M
LOCATION:MRT 256
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Sphinx and Postgres - Full Text Search extension
UID:611@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/611.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Usually “large” databases are considered as such for the high n
 umber of records they hold\, reaching billions or even more than that. But 
 what about creating a billion... tables?Sometime ago\, this apparently craz
 y question was found in a database soup  (http://it.toolbox.com/blogs/datab
 ase-soup/one-billion-tables-or-bust-46270). It may not be your day-to-day t
 ask\, but the task of creating them exposes some topics about PostgreSQL in
 ternals\, performance and large databases that may be really worth for your
  day-to-day.Join us for this talk\, where we'll be discussing topics such a
 s catalogue structure and storage requirements\, table speed creation\, dif
 ferences between PostgreSQL versions and durability vs. table creation spee
 d tradeoffs\, among others. And\, of course\, how long a “\dt” takes on a 1
 B tables database :)
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T150000
DURATION:PT1H00M
LOCATION:MRT 256
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:The Billion Tables Project - Aka how long a "\dt" takes on a 1B tab
 les database
UID:595@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/595.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:The Schemaverse is a space-based strategy game implemented enti
 rely within a PostgreSQL database. 
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T123000
DURATION:PT1H00M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:The PGCon Schemaverse Tournament   - A DEFCON 21 Qualifier
UID:527@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/527.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Play Tourist
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130526T090000
DURATION:PT5H00M
LOCATION:Out and about
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Tourist Time - See the sights in and/or around Ottawa
UID:632@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/632.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:This is where we will decide the content of the rest of the day
 .
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130525T100000
DURATION:PT1H00M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Unconference - Room #1
UID:637@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/637.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Turn up here to organize the rest of the day.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130525T110000
DURATION:PT2H00M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Unconference - Room #1
UID:626@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/626.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:The content of the day will be decided on the day.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130525T140000
DURATION:PT3H30M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Unconference - Room #1 afternoon
UID:629@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/629.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:The content of the day will be decided on the day.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130525T110000
DURATION:PT2H00M
LOCATION:MRT 256
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Unconference - Room #2
UID:628@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/628.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:The content of the day will be decided on the day.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130525T140000
DURATION:PT3H30M
LOCATION:MRT 221
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Unconference - Room #2
UID:630@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/630.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:The content of the day will be decided on the day.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130525T140000
DURATION:PT3H30M
LOCATION:MRT 256
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Unconference - Room #2
UID:631@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/631.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:The content of the day will be decided on the day.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130525T110000
DURATION:PT2H00M
LOCATION:MRT 221
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Unconference - Room #2
UID:627@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/627.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Whenever you perform point-in-time-recovery or failover in Post
 greSQL\, a new timeline is created. In the best case\, timelines help you s
 tay sane in complicated recovery situations and keep your database consiste
 nt. In the worst case\, they will thoroughly confuse you.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T133000
DURATION:PT1H00M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Understanding PostgreSQL timelines
UID:564@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/564.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:When problems arise\, every DBA wants to know what the database
  has been up to.  If your best idea so far has been to parse the log files 
 or load the CSV logs into another database\, you might want to learn about 
 a better way.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130523T133000
DURATION:PT1H00M
LOCATION:MNT 202
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Use logging hooks for real-time log analysis - If you want to know 
 right now what your server has been doing
UID:591@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/591.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Redis is a high performance in-memory distributed data store\, 
 which can work well in conjunction with PostgreSQL in certain types of appl
 ications. 
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T100000
DURATION:PT1H00M
LOCATION:MRT 221
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Using PostgreSQL with Redis  - Using native wrappers and a Foreign 
 Data Wrapper for two-way Redis integration 
UID:574@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/574.en.html
END:VEVENT
BEGIN:VEVENT
CATEGORIES:Lecture
DESCRIPTION:Postgres comes with several introspection tools out of the box.
  Some are easier to understand than others\, but they are all useful. Recen
 t improvements in 9.2's pg_stat_statements make it even easier gain insight
 s into the performance of your application.This talk will explore these bui
 lt in tools\, and what it takes to combine them to provide real-time visual
 izations of your database.
DTSTAMP:20130508T200819
DTSTART;TZID=America/Montreal:20130524T133000
DURATION:PT1H00M
LOCATION:MRT 221
SEQUENCE:0
STATUS:CONFIRMED
SUMMARY:Visualizing Postgres - in realtime
UID:588@PGCon2013@pentabarf.org
URL:http://www.pgcon.org/2014/schedule/events/588.en.html
END:VEVENT
END:VCALENDAR