BEGIN:VCALENDAR CALSCALE:GREGORIAN PRODID:-//Pentabarf//Schedule//EN VERSION:2.0 BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:PostgreSQL's built in replication is available for a while now\ , yet all the previous solutions enjoy ongoing popularity. For the experts\ , this is hardly surprising. A) because none of the solutions was ever mean t to replace anything else. B) because replication is one single term for s everal different attempts of solving a subset of many different problems. F or IT decision makers this can be rather confusing. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120517T110000 DURATION:PT1H00M LOCATION:MRT 218 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:"Cheap\, Fast AND Good" .... CHECK - A checklist for database repli cation shoppers. UID:441@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/441.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Gentlemen\, start your database engines! PostgreSQL 9.2 beta is here\, and it's faster and more exciting than ever before. Come down to t he track and join us for a high-speed tour of the next version like never b efore! DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120517T093000 DURATION:PT1H00M LOCATION:MRT 218 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:9.2: Full Throttle Database - New Feature Grand Prix UID:423@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/423.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:A database commit can be the most expensive single operation th atits users have to wait for. Recent trends in the database industryhave p roven some applications are willing to accept durability loss\,when it must be sacrificed to reach performance goals. And an inevitabledownside of mo re durable approaches like Synchronous Replication aretheir impact on serve r commit speed.Some of the fundamental limitations here are physical ones: disk rotation\,network performance\, and the speed of light. Recent perfo rmance improvementschanges for PostgreSQL 9.2 aim at getting closer to the theoretical bestpossible behavior here in every situation. It's more impor tant than ever to tell when the limit you're hitting is a physical one\, an d when it'ssomething you can address with a software change. Controlling c ommitbatch size and the number of concurrent clients is getting even moreim portant as PostgreSQL is deployed onto cloud and other virtual hardwareenvi ronments. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T100000 DURATION:PT1H00M LOCATION:MRT 218 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:A Batch of Commit Batching UID:453@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/453.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:A few years ago\, we started a project to upgrade our multi-ter abyte database from 8.3 to 8.4. Along the way we encountered a number of di fferent obstacles and roadblocks which caused us to postpone the project\, but this past fall we finally made it through phase 1 of the project\, whic h by now had become an upgrade from 8.3 to 9.1. The course of the talk will cover several tools and tactics we had to use to get pg_upgrade to complet e successfully\, including all the different ways that things blew up on us . DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T163000 DURATION:PT1H00M LOCATION:MRT 218 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Big Bad "Upgraded" PostgreSQL UID:488@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/488.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:The Traditional Closing Session DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T173000 DURATION:PT1H00M LOCATION:MRT 218 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Closing sessions - prizes\, auctions\, fun\, games UID:496@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/496.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:NTT (Nippon Telegraph and Telephone) group has made effort to i ntroduce PostgreSQL to its production systems that are large and mission-cr itical. Introducing PostgreSQL\, we found it may be an obstaclethat operati on tools for PostgreSQL are not provided enough.So we have developed tools for backup\, data load\, and performancemonitoring. In the talk\, we will i ntroduce these tools and how to improve database operation using them. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120517T130000 DURATION:PT1H00M LOCATION:MRT 212 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Database Ops - Easy and Effective Operation for production systems with PostgreSQL UID:434@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/434.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Using the StackOverFlow datasets\, we'll ditch all the drama of a Microsoft stack and convert from SQL Server to Postgres on Windows. Once we do that\, we'll migrate our entire DB and Web App from Microsoft to Lin ux using Postgres and Mono with as few code changes as possible. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T100000 DURATION:PT1H00M LOCATION:MRT 205 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Dear SQL Server\, I'm filing for divorce. - Falling in love with th e free spirit of Postgres UID:462@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/462.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Finding similar objects is an ubiquitous task in day-to-day act ivity of developers of informational services. We present PostgreSQL exten sion\, which provides an effective way to find similar objects in database\ , as well as several usage examples. The extension provides several methods to calculate sets similarity and similarity operator with indexing suppor t on the base of GiST and GIN frameworks. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120517T130000 DURATION:PT1H00M LOCATION:MRT 219 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Finding Similar - Effective similarity search in database UID:443@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/443.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:An overview of Postgres' built in replication system\, starting from PITR and going to cascading replication with demonstration's along th e way. There will be more emphasis on the more recent and interesting techn ologies such as streaming replication and hot standby. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120516T090000 DURATION:PT3H00M LOCATION:MRT 212 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Getting Hot and Streamy with Postgres - Using Postgres' built in re plication facilities UID:493@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/493.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:A place to gather... DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120516T180000 DURATION:PT5H00M LOCATION:L152 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Hacker Lounge - meet\, greet\, code\, slack UID:506@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/506.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:A place to gather... DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T210000 DURATION:PT3H00M LOCATION:L152 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Hacker Lounge - meet\, greet\, code\, slack UID:507@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/507.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:A place to gather... DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120517T210000 DURATION:PT3H00M LOCATION:L152 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Hacker Lounge - meet\, greet\, code\, slack UID:508@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/508.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:PostgreSQL's extensibility is well known. Most people have hear d of user types\, user operators\, the new extension capability\, and such. But few know about hooks in PostgreSQL. This talk will cover all kinds of hooks available in PostgreSQL\, and will show some tools using them already . DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T113000 DURATION:PT1H00M LOCATION:MRT 212 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Hooks in PostgreSQL UID:466@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/466.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Row locking is a mechanism that lets Postgres maintain strict c onsistency in certain database constraints\, such as foreign keys. However \, Postgres has historically only provided share and exclusive row locking\ , which I'll show to have significant drawbacks for concurrency. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T133000 DURATION:PT1H00M LOCATION:MRT 212 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Improving foreign key concurrency - To lock and not to block UID:483@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/483.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Regular expressions (regex) are powerful tool for text processi ng. When dealing with large string collections it's important to search fas t on that collections (i.e. search using index). Indexing for regex search is a quite hard task. This talk presents novel technique (and WIP patch for PostgreSQL implementing it) for regex search using trigram indexes. Propos ed technique provides more comprehensive trigram extraction than analogues\ , i.e. higher performance. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T150000 DURATION:PT1H00M LOCATION:MRT 212 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Index support for regular expression search UID:383@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/383.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:One thing is certain: databases in the future are not going to look much like today. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120517T090000 DURATION:PT0H30M LOCATION:MRT 218 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Keynote UID:497@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/497.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Once a Top-10 internet audience site. 32 million users. Billion s of photos and comments\, more than 6TB of them. Migrating away from MySQL to PostgreSQL!This talk will share hindsights about the why and the how of that migration\, what problems couldn't be solved without moving away and how the solution now looks. The tools used for migrating away the data\, th e methods and will detail the new architecture. And the new home\, in the c loud! DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120517T130000 DURATION:PT1H00M LOCATION:MRT 218 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Large Scale MySQL Migration - to PostgreSQL! UID:431@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/431.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:20120611T182036 DTSTART;TZID=America/Montreal:20120517T160000 DURATION:PT1H00M LOCATION:MRT 218 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Lightning talks - Short sharp descriptions of short topics UID:489@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/489.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:MADlib is an open-source library for scalable in-database analy tics. Itprovides data-parallel implementations of mathematical\, statistica l andmachine learning methods for structured and unstructured data. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120517T110000 DURATION:PT1H00M LOCATION:MRT 212 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:MADlib - An open source machine learning library on RDBMS for Big D ata age UID:404@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/404.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:20120611T182036 DTSTART;TZID=America/Montreal:20120517T180000 DURATION:PT3H00M LOCATION:Out and about SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Major Social Event! - sponsored by EnterpriseDB UID:504@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/504.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Come and join us for an evening of food and drink at Patty Bola nd's in the Market. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T190000 DURATION:PT2H00M LOCATION:Patty Boland's (upstairs) SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Major Social Event! - sponsored by Heroku UID:502@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/502.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:PostGIS is an extension to PostgreSQL that turns PostgreSQL int o a superb spatial database. Storing spatial data in PostgreSQL is a great way too use up the space on your SSD's however using the data to make maps is much more fun. This talk is aimed at people with limited GIS experienc e and will talk about how to use OpenStreetMap data for map making. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T090000 DURATION:PT1H00M LOCATION:MRT 212 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Making your own maps - An introduction in using free Geospatial dat a UID:432@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/432.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:In this two part course you will learn the essential details of PostgreSQL configuration\, security\, maintenance\, monitoring\, tuning\, backups\, recovery. The course is designed for people with experience in da tabase administration but who are new to the Postgres platform.There will b e a 1hr lunch break at noon. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120515T130000 DURATION:PT3H00M LOCATION:MRT 212 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Mastering PostgreSQL Administration - afternoon session UID:495@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/495.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:In this two part course you will learn the essential details of PostgreSQL configuration\, security\, maintenance\, monitoring\, tuning\, backups\, recovery. The course is designed for people with experience in da tabase administration but who are new to the Postgres platform.There will b e a 1hr lunch break at noon. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120515T090000 DURATION:PT3H00M LOCATION:MRT 212 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Mastering PostgreSQL Administration UID:470@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/470.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Postgres is used to manage data from the Ozone Monitoring Instr ument aboard NASA's Aura spacecraft. The database implementation must hand le large volumes of complex data transmitted continually from the satellite and generated by processing-intensive analyses performed by a team of atmo spheric scientists. This talk will describe the architecture and some of t he challenges faced. Focus will be given to our replication efforts\, soft ware developed for monitoring\, and ongoing work to create a decentralized network of services commnicating through a RESTful interface. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T113000 DURATION:PT1H00M LOCATION:MRT 205 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Monitoring Ozone Levels with Postgresql - Database Streaming Replic ation and Monitoring UID:426@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/426.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:In 2011 we moved the Mozilla crash reporting system from old cr eaky hardware in San Jose to a new shiny datacenter in Phoenix. This system contains more than 40TB of data in HBase\, the Hadoop database\, and Postg reSQL. The data collecting app has a requirement for close to 100% uptime. On top of that we have data processing\, an API\, and a webapp. After many months of work\, the migration went seamlessly. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T113000 DURATION:PT1H00M LOCATION:MRT 218 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Moving Day: Migrating Big Data from A to B UID:492@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/492.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Learn about various OLTP Performance benchmark kits \, when to use them and what to know when comparing numbers with other databases. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T133000 DURATION:PT1H00M LOCATION:MRT 205 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:OLTP Performance Benchmarks Overview UID:387@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/387.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Python is one of the most popular application programming langu ages and there's a plethora of PostgreSQL libraries and utilities for Pytho n.This talk will try to give an overview of the contemporary Python-Postgre SQL landscape in a way that's useful both for Python programmers starting o n a PostgreSQL project and DBAs dealing with what those programmers wrote. We'll try cover a slightly opinionated selection of libraries\, frameworks and technologies and give some recommendations. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T100000 DURATION:PT1H00M LOCATION:MRT 212 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:On snakes and elephants - Using Python with and in PostgreSQL UID:417@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/417.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:We will present the results of an investigation into the use of PostgreSQL and PL/R in conjunction with a server monitoring application to perform predictive analytics of server performance. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120517T143000 DURATION:PT1H00M LOCATION:MRT 219 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:PL/R Tricks - Server Monitoring with Predictive Analytics UID:437@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/437.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:The upcoming PostgreSQL 9.2 release features a large number of performance enhancements by many different authors\, including heavyweight lock manager improvements\, reduced lock hold times in key hot spots\, bett er group commit\, index-only scans\, better write-ahead log parallelism\, s orting improvements\, and a userspace AVC for sepgsql. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T150000 DURATION:PT1H00M LOCATION:MRT 218 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Performance Improvements in PostgreSQL 9.2 - Bigger servers\, bigge r problems UID:416@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/416.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Amazon Web Services (AWS) has become a very popular platform fo r deploying PostgreSQL-backed applications. But it's not a standard hosting platform. We'll talk about how to get PostgreSQL to run efficiently and sa fely on AWS. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T133000 DURATION:PT1H00M LOCATION:MRT 218 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:PostgreSQL on AWS - EC2 with somewhat reduced tears UID:419@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/419.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Range Types didn't exist before\, why do we need them now? How do they work? Why is "Temporal" important if we already have timestamps? Ho w do we apply these concepts before deploying PostgreSQL 9.2? What's left t o be done\, and what solutions are in the works? DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120517T143000 DURATION:PT1H00M LOCATION:MRT 212 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Range Types and Temporal: Past\, Present\, and Future UID:439@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/439.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Pick up your registration pack DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120516T150000 DURATION:PT4H00M LOCATION:Royal Oak SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Registration pickup - The social way to register: at the pub UID:498@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/498.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Launched by the Georgia Public Library System in September 2006 to manage and circulate materials through a consortia of over 200 public l ibraries\, Evergreen has since been adopted by over 1\,000 public and acade mic libraries across more than 30 states and provinces. From the beginning\ , Evergreen's distributed architecture has bet heavily on PostgreSQL featur es\, relying on custom functions\, triggers and rules\, full-text search\, XML support\, inheritance\, and recently HSTORE to provide reliable high-pe rformance support for the day-to-day operations of libraries. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T150000 DURATION:PT1H00M LOCATION:MRT 205 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Running libraries on PostgreSQL - The Evergreen library system's (a b)use of PostgreSQL UID:465@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/465.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Schemaless database are a joy to use because they make it easy to iterate on your app\, especially early on. And to be honest\, the relati onal model isn't always the best fit for real-world evolving and messy data . DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120517T110000 DURATION:PT1H00M LOCATION:MRT 219 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Schemaless SQL - The Best of Both Worlds UID:468@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/468.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Compete against your fellow PostgreSQL users for prizes and the honor of the Schemaverse Champion title. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120517T120000 DURATION:PT1H00M LOCATION:MRT 212 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Schemaverse - Learn more about the tournament format\, available pr izes\, game mechanics or even simply discuss the idea UID:509@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/509.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:SQL change management has always sucked. This talk introduces S qitch\, the VCS-aware SQL change management application that doesn’t suck. Come see how it works\, learn the few simple rules you need to get the most out of it\, and liberate yourself from the suckitude. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T163000 DURATION:PT1H00M LOCATION:MRT 205 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Simple SQL Change Management with Sqitch UID:479@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/479.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Horizontal scale-out of applications using Postgres is typicall y a time-consuming\, expensive\, error-prone task. In spite of that\, hor izontal scale-out is achievable\, even if not well-supported by the logical constructs Postgres exposes.This talk is intended to share what we've lear ned from both our experiences at Heroku and\, more importantly\, the litany of customers that we are privileged to talk to about their problems. From these\, a few choice gaps in functionality are highlighted for improvement . DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T090000 DURATION:PT1H00M LOCATION:MRT 218 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:The Horizontal Struggle - Improving the Experience of Scale-Out UID:446@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/446.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:The new binary replication protocols and tools in PostgreSQL 9. 0 and 9.1 are a popular new feature - but they can also be used for other t hings than just replication! DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T163000 DURATION:PT1H00M LOCATION:MRT 212 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:The PostgreSQL replication protocol\, tools and opportunities UID:450@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/450.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Explore Ottawa DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120519T100000 DURATION:PT5H00M LOCATION:Out and about SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Tourist stuff - Spend some time exploring UID:503@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/503.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Postgres-XC (simply XC) is write-scalable PostgreSQL cluster\, which will be generally available by early May\, 2012.So far\, XC is only o ne write-scalable\, symetric database cluster solution available as open so urce. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120516T130000 DURATION:PT3H00M LOCATION:MRT 212 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Tutorial - Configuring write-scalable PostgreSQL cluster - Postgres -XC primer and more UID:424@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/424.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Locking is critical for providing high concurrency for any data base — you cannot fully utilize your hardware if locking is throttling its use. This talk explores all aspects of locking in Postgres by showing queri es and their locks\; covered lock types include row\, table\, shared\, excl usive\, and advisory lock types. The high concurrency provided by Multivers ion Concurrency Control (MVCC) is also covered. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120517T143000 DURATION:PT1H00M LOCATION:MRT 218 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Unlocking the Postgres Lock Manager UID:454@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/454.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:PostgreSQL's object relational heritage makes it an outstanding choice for developing web applications that have a rich object model domai n. See how PostgreSQL's object relational features allow for building datab ase models to support a NodeJS data service feeding a 100% JavaScript web c lient. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120517T093000 DURATION:PT1H00M LOCATION:MRT 212 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Using PostgreSQL in modern enterprise web applications - Using HTML 5\, JavaScript\, NodeJS with PostgreSQL UID:415@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/415.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Describes the Write-Ahead-Log Internals of PostgreSQL system. I mprovements in WAL system that can be done to improve the performance. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120518T090000 DURATION:PT1H00M LOCATION:MRT 205 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:WAL Internals Of PostgreSQL UID:408@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/408.en.html END:VEVENT BEGIN:VEVENT CATEGORIES:Lecture DESCRIPTION:Writing a foreign data wrapper (FDW) for PostgreSQL seems easy. However\, there are many pitfalls. DTSTAMP:20120611T182036 DTSTART;TZID=America/Montreal:20120517T093000 DURATION:PT1H00M LOCATION:MRT 219 SEQUENCE:0 STATUS:CONFIRMED SUMMARY:Writing a foreign data wrapper - Experiences with Informix UID:440@PGCon2012@pentabarf.org URL:http://www.pgcon.org/2012/schedule/events/440.en.html END:VEVENT END:VCALENDAR