BEGIN:VCALENDAR VERSION:2.0 CALSCALE:GREGORIAN PRODID:-//Pentabarf//Schedule//EN BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/351.en.html DTSTART;TZID=America/Montreal:20110519T100000 UID:351@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:SQL/MED\, Sync Rep\, SSI\, Streaming Backups\, SE-PostgreSQL\, Writeable CTEs\, Range Types\, per-Column Collations\, EXTENSIONs\, directo ry archives\, checkpoint goggles\, VIEW triggers\, extensible ENUMs\, and m ore. SUMMARY:9.1 Mystery Tour - What's in the upcoming version STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/360.en.html DTSTART;TZID=America/Montreal:20110520T113000 UID:360@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:OmniPITR is a set of scripts designed to help manage and mainta in WAL files for Postgres database. It was created in an effort to replace the myriad scripts we've encountered\, and written\, managing our clients P ostgres installs over the years. It includes tools for both archiving\, res toration\, and creating portable backups on both the master and slave insta nce. SUMMARY:Advanced WAL file management with OmniPITR. STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/278.en.html DTSTART;TZID=America/Montreal:20110520T100000 UID:278@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:This is a presentation on how-to develop a simple Android appli cation that uses the PostgreSQL JDBC driver to communicate directly with a database. Use the Android SDK with Eclipse to build and deploy an applicati on. Familiarity with Java programming and XML recommended. SUMMARY:Android & PostgreSQL - How to develop an Android App for PostgreSQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/343.en.html DTSTART;TZID=America/Montreal:20110519T113000 UID:343@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:Ora2Pg is a GPLv3 licensed tool used to help migrate an Oracle database to a PostgreSQL compatible database. Ora2Pg can be used from rever se engineering Oracle database to huge enterprise database migration or sim ply to replicate some Oracle data into a PostgreSQL database. SUMMARY:Best practices with Ora2Pg - Migrating Oracle databases to Postgres QL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/375.en.html DTSTART;TZID=America/Montreal:20110520T173000 UID:375@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:The Traditional Closing Session SUMMARY:Closing sessions - prizes\, auctions\, fun\, games STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1120 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/300.en.html DTSTART;TZID=America/Montreal:20110519T100000 UID:300@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:In todays world\, nobody (should) deploy a web application faci ng theinternet without having a proper caching system in place. There arema ny different solutions to choose from\, from manual use of memcachedthrough framework integrated caching to external caches like Squid orVarnish. Most modern frameworks come with integrated functionality forat least one of th ese methods\, and often more than one. SUMMARY:Data-driven cache invalidation STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/361.en.html DTSTART;TZID=America/Montreal:20110519T100000 UID:361@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:Most people have come to understand simple replication based ho rizontal scale-out\, but while this technique works pretty well for some re ad loads\, there are system where either the amount of data involved is too great for a single system\, or the write based load goes beyond the capaci ty of a single machine. In these cases we must turn to complex systems of f ederated databases to build database systems that can sustain perpetual gro wth. SUMMARY:Database Scalability Patterns: Sharding for Unlimited Growth STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/291.en.html DTSTART;TZID=America/Montreal:20110520T150000 UID:291@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:So you've solved a common problem in PostgreSQL\, a serious pai n point that lots of other people could take advantage of. You want to open -source the code\, and would like to package it up and distribute it where people can find it\, read its docs\, and download and install it.The newest destination for distributing PostgreSQL extensions is [PGXN](http://pgxn.o rg/)\, the PostgreSQL Extension network. PGXN offers a central index of Pos tgreSQL extensions and their documentation\, making it easy for people to f ind an install extensions. How do you optimize your extension distribution for maximum PGXN exposure? By careful packaging\, thorough documentation\, and simple installation. Join me for an overview of how best to achieve tha t — including how to build extensions compatible with PostgreSQL 9.1's impr oved extension support. SUMMARY:Distributing Extensions on PGXN - Optimal PGXN exposure via Smart d istribution packaging STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/332.en.html DTSTART;TZID=America/Montreal:20110520T133000 UID:332@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:We introduce and describe two modules that grew from the need t o performintegrated and efficient Bioinformatics tasks in PostgreSQL: PostB io\, a set ofmethods to store and query genomic sequences and features\, an d PostStat\, acollection of statistical functions that allow for integrated statisticaltests. A few practical examples will be presented to showcase t he modules. SUMMARY:Doing Bioinformatics in PostgreSQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1120 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/282.en.html DTSTART;TZID=America/Montreal:20110520T133000 UID:282@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:This is advanced talk will be an in-depth discussion of HTSQL's query language's design\, focusing primarily on techniques usedfor join spe cification and translation into SQL. It should be ofbroad interest to core PostgreSQL core developers. It will likelynot be that useful for applicat ion developers or users of HTSQLsince the talk will be focusing on translat ion mechanics. SUMMARY:Exploring Automated Join Construction - An discussion of HTSQL's jo in algebra and translation to SQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/280.en.html DTSTART;TZID=America/Montreal:20110520T163000 UID:280@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:PostgreSQL extensibility is remarkable but incomplete. It lacks dump andrestore support. SUMMARY:Extensions Development - both of the feature and developments using it STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1120 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/350.en.html DTSTART;TZID=America/Montreal:20110519T163000 UID:350@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:What does the planner do and why does it do it? How can it be improved? SUMMARY:Hacking the Query Planner STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/382.en.html DTSTART;TZID=America/Montreal:20110520T133000 UID:382@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:What does the planner do and why does it do it? How can it be improved? PART IIThis is a continuation of Tom's talk from yesterday. SUMMARY:Hacking the Query Planner II STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1120 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/303.en.html DTSTART;TZID=America/Montreal:20110519T133000 UID:303@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:Writing a PostgreSQL patch can be difficult\, and getting it ac cepted can require even more work than writing it in the first place. SUMMARY:How To Get Your PostgreSQL Patch Accepted - In short: -1 from me. regards\, tom lane STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1120 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/344.en.html DTSTART;TZID=America/Montreal:20110520T100000 UID:344@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:PostgreSQL v9.1 shall be released with a long-awaited feature t hat enables to apply label based mandatory access control. It was primarily developed to integrate security model of SELinux\, however\, it was evolve d to more generic design by community efforts. Nowadays\, we can apply an a dditional security mechanism from a difference perspective in addition to t he default database privileges.This session offers a brief overview of this model\, an introduction of what's new in v9.1 and limitations to be overco me in the future release. SUMMARY:Label Based Mandatory Access Control on PostgreSQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H00M LOCATION:DMS 1120 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/340.en.html DTSTART;TZID=America/Montreal:20110518T090000 UID:340@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:Object-Relational Mappers (ORMs) are the primary interface that application programmers now use to interact with SQL databases. Any DBA ca n list the problems that they create\, but how can we move on to solutions that don't involve a complete reengineering the ORM-database interaction pa radigm? Rather than simply declaim that ORMs are bad\, let's find a way of mitigating the problems that existing ORMs create. SUMMARY:Life with Object-Relational Mappers - Or\, how I stopped worrying a nd learned to love the ORM STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/369.en.html DTSTART;TZID=America/Montreal:20110519T173000 UID:369@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:A regular feature\, PGCon will have a Lightning talks session\, with presentations on diverse topics. SUMMARY:Lightning talks - Short sharp descriptions of short topics STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT2H00M LOCATION:DMS 1120 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/297.en.html DTSTART;TZID=America/Montreal:20110519T113000 UID:297@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:Multi-Version Concurrency Control (MVCC) allows Postgres to off er highconcurrency even during significant database read/write activity. MV CCspecifically offers behavior where "readers never block writers\, andwrit ers never block readers". SUMMARY:MVCC Unmasked STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/366.en.html DTSTART;TZID=America/Montreal:20110519T133000 UID:366@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:Size can creep up on you. Some day you may wake up to a multi-t erabyte Postgres system handling over 3000 tps staring you down. Learn the best ways to manage these systems as they grow\, and find out what new feat ures in 9.0 have made life easier for administrators and application develo pers working with big data. SUMMARY:Maintaining Terabytes - 10 Things to Watch Out For When PostgresSQL Gets Big STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT2H00M LOCATION:The Velvet Room SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/380.en.html DTSTART;TZID=America/Montreal:20110519T183000 UID:380@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:Come and join us for the major evening social event of PGCon 20 11! SUMMARY:Major Social Event! - sponsored by EnterpriseDB STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1120 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/307.en.html DTSTART;TZID=America/Montreal:20110519T150000 UID:307@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:We will present how to introduce PostgreSQL into NTT’s telecomm unication systems. To inform the merit of PostgreSQL for IT system managers we evaluated its performance and showed applicable field of our production systems. To broaden the field we have resolved performance problems like a s performance glitch at checkpoints and improved its usability with home-ma de tools such as pg_bulkload\, pg_statsinfo and so on. All these efforts an d their results are worth being shared with who plan and proceed PostgreSQL ’s enterprise use. SUMMARY:NTT’s Case Report - Introduce PostgreSQL into reliable and large-sc ale telecommunication support system STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT4H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/374.en.html DTSTART;TZID=America/Montreal:20110521T093000 UID:374@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:Procedural Language SUMMARY:PL Developer Summit - PL/Mania STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/352.en.html DTSTART;TZID=America/Montreal:20110519T150000 UID:352@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:2D and 3D Image data is increasing important. New 3D scanning devices are being used to map a variety of large and small spaces and objec ts. Large GIS data sets are being acquired with new scanners. Computation photography allows the manipulation of images for many applications both sc ientific and social. GPUs are increasingly being used to accelerate image based computations. This presentation illustrates how PostgreSQL can store and process images using GPU hosted stored procedures\, written in OpenCL. SUMMARY:Parallel Image Searching Using PostgreSQL and PgOpenCL - Running PostgreSQL Stored Procedures on a GPU STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/373.en.html DTSTART;TZID=America/Montreal:20110519T090000 UID:373@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:Paul Ramsey has been working with geospatial software for more than 10years\, as programmer and consultant. He co-founded the PostGIS spat ialdatabase project in 2001\, and is currently an active developer andmembe r of the project steering committee. In 2008\, Paul received theSol Katz Aw ard for achievement in open source geospatial software. SUMMARY:PostGIS Knows Where You Are - Should you be Worried? STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/292.en.html DTSTART;TZID=America/Montreal:20110519T163000 UID:292@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:Logs can tell you a lot about what's going on in your database: which user logged in when\, what queries they ran and how long they took\ , when the database restarted. We'll walk through the various logging conf iguration options PostgreSQL offers to help you figure out how to get what you need in a format that's useful to you. We'll also talk about what to d o with your logs once you have them (hint: you don't have to stay up at ni ght reading through them!) and\, time permitting\, wrap up with a group dis cussion. SUMMARY:PostgreSQL Logging - How to get the most out of your activity log STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H00M LOCATION:DMS 1120 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/336.en.html DTSTART;TZID=America/Montreal:20110517T130000 UID:336@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:PostgreSQL is a database system that can deliver excellent perf ormance for a wide variety of applications. But it's easy to run into an i ssue that keeps you from seeing its full potential. There are a few basic PostgreSQL configuration and use misunderstandings that cause most of the e arly performance issues administrators and developers encounter. SUMMARY:PostgreSQL Performance Pitfalls - Keeping yourself out of the pit STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/311.en.html DTSTART;TZID=America/Montreal:20110520T100000 UID:311@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:Range Types are a new feature that captures ranges -- ranges of time\, ranges of numbers\, ranges of dates -- and gives users the ability to create their own range types. Using Range Types improves performance by using range indexes\, simplifies your queries and schema\, and enables adva nced features such as using Exclusion Constraints to prevent overlap. SUMMARY:Range Types - Range Types and Temporal Data STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/353.en.html DTSTART;TZID=America/Montreal:20110519T133000 UID:353@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:Federation Database System solves transparent access to heterog eneous DBMS to realize Optimized Database schema design according to optim ized business process. Our database team develops Real Federation Database System leveraging PostgreSQL FDW. This federation system enhances the curre nt optimization of Foreign Scan and adds Foreign Data Wrapper for another R DBMS such as Oracle and Microsoft SQL Server. SUMMARY:Real Federation Database System leveraging PostgreSQL FDW STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT7H00M LOCATION:Royal Oak SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/379.en.html DTSTART;TZID=America/Montreal:20110518T150000 UID:379@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:Pick up your registration pack SUMMARY:Registration pickup - The social way to register: at the pub STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/368.en.html DTSTART;TZID=America/Montreal:20110519T113000 UID:368@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:Patch reviewing is an important part of moving PostgreSQL forwa rd. It's critical for anyone submitting patches to PostgreSQL to also unde rstand how to review patches\, too. This talk will go through the steps of patch review\, including the most important piece- code review. SUMMARY:Review of Patch Reviewing - How to Review Patches for PostgreSQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/286.en.html DTSTART;TZID=America/Montreal:20110520T163000 UID:286@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:A specific example of using PostgreSQL in enterprise level OSS system for largest pan-russian cellular provider - technology choice reaso ning\, implementation\, maintenance and performance issues. SUMMARY:Running PostgreSQL in enterprise level telco systems STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/309.en.html DTSTART;TZID=America/Montreal:20110520T113000 UID:309@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:We want to present a prototype of new indexing infrastructure\, called SP-GiST\, which greatly extends current extendability of PostgreSQL to support space-partitioning trees\, as well as a family of digital trees like suffix tree\, patricia. We'll present programming interface\, example s of realizations of some useful datatypes. Also\, we'd like to discuss som e implementation issues and roadmap for inclusion to PostgreSQL. SUMMARY:SP-GiST - a new indexing infrastructure for PostgreSQL - Space-Part itioning trees in PostgreSQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/296.en.html DTSTART;TZID=America/Montreal:20110519T163000 UID:296@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:This talk explores the ways attackers with no authorized databa se accesscan steal Postgres passwords\, see database queries and results\, and evenintercept database sessions and return false data. SUMMARY:Securing PostgreSQL From External Attack STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1120 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/333.en.html DTSTART;TZID=America/Montreal:20110520T163000 UID:333@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:Serializable isolation makes it easier to reason about database behavior because concurrent transactions appear to have executedsequentiall y. However\, Postgres has historically only providedsnapshot isolation\, ev en at the SERIALIZABLE isolation level\, whichcan expose anomalous states t o queries. SUMMARY:Serializable Snapshot Isolation in Postgres - Making ISOLATION LEVE L SERIALIZABLE Provide Serializable Isolation STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/337.en.html DTSTART;TZID=America/Montreal:20110520T150000 UID:337@PGCon2011@pentabarf.org DTSTAMP:20110611T153453 CATEGORIES:Lecture DESCRIPTION:One of the most difficult things to do with a database system i s handle a high volume of writes\, whether it's from a single user or thous ands. The steps a database like PostgreSQL takes to protect your data are expensive\, and it's hard to split them into independent pieces. Recent ch anges available in the upcoming PostgreSQL 9.1 have given new insight into exactly how PostgreSQL systems that write constantly break down under serio us loads. SUMMARY:The Write Stuff - Reaching peak write performance under heavy loads STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT5H00M LOCATION:Out and about SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/376.en.html DTSTART;TZID=America/Montreal:20110521T100000 UID:376@PGCon2011@pentabarf.org DTSTAMP:20110611T153454 CATEGORIES:Lecture DESCRIPTION:Explore Ottawa SUMMARY:Tourist stuff - Spend some time exploring STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H00M LOCATION:DMS 1120 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/357.en.html DTSTART;TZID=America/Montreal:20110518T130000 UID:357@PGCon2011@pentabarf.org DTSTAMP:20110611T153454 CATEGORIES:Lecture DESCRIPTION:Despite the NoSQL movement trying to flag traditional databases as a dying breed\, the RDBMS keeps evolving and adding new powerful weapon s to its arsenal. In this talk we'll explore Common Table Expressions (SQL- 99) and how SQL handles recursion\, breaking the bi-dimensional barriers an d paving the way to more complex data structures like trees and graphs\, an d how we can replicate features from social networks and recommendation sys tems. We'll also have a look at window functions (SQL:2003) and the advance d reporting features they make finally possible. SUMMARY:Trees and Graphs in the database - RDBMS in the social networks age STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/287.en.html DTSTART;TZID=America/Montreal:20110519T150000 UID:287@PGCon2011@pentabarf.org DTSTAMP:20110611T153454 CATEGORIES:Lecture DESCRIPTION:In this session we take a look at the Light Weight Lock facilit y in PostgreSQL and the various lwlocks. SUMMARY:Understanding PostgreSQL LWLocks STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1120 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/356.en.html DTSTART;TZID=America/Montreal:20110520T150000 UID:356@PGCon2011@pentabarf.org DTSTAMP:20110611T153454 CATEGORIES:Lecture DESCRIPTION:Postgres is a powerful database\, especially when coupling it w ith PostGIS to make it spatially aware. Using PostgreSQL and PostGIS allows World Flight Planner to provide advanced flight planning tools to both pri vate and commercial pilots.Using PostgreSQL and PostGIS allows you to acces s and modify your spatial data using SQL. This talk will provide an overvie w on the advantages to using PostGIS\, how to properly store and query your geographic data\, and offer some solutions to common problems. SUMMARY:Using PostgreSQL for Flight Planning - How PostgreSQL is being used at www.worldflightplanner.com STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H00M LOCATION:DMS 1120 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/305.en.html DTSTART;TZID=America/Montreal:20110517T090000 UID:305@PGCon2011@pentabarf.org DTSTAMP:20110611T153454 CATEGORIES:Lecture DESCRIPTION:The PostgreSQL system catalogs store metadata about SQL objects such as tables\, columns\, functions\, schemas\, and more. This talk will explore the organization and structure of the system catalogs and explain h ow you can use these catalogs to manage and tune your database. SUMMARY:Using The PostgreSQL System Catalogs - Database Introspection with PostgreSQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1120 SEQUENCE:0 URL:http://www.pgcon.org/2011/schedule/events/378.en.html DTSTART;TZID=America/Montreal:20110520T113000 UID:378@PGCon2011@pentabarf.org DTSTAMP:20110611T153454 CATEGORIES:Lecture DESCRIPTION:In SQL\, Common Table Expressions are a way of creating and usi ng views at run time\, but only in read queries. Here we discover ways to u se them in writes.Find out about this exciting new feature! SUMMARY:Writeable CTEs - A Revolution in SQL STATUS:CONFIRMED END:VEVENT END:VCALENDAR