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/2009/schedule/events/196.en.html DTSTART;TZID=America/Montreal:20090521T100000 UID:196@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:The data warehousing startup Aster Data will explain how they h ave built a petabyte-scale data warehousing platform on top of regular open source PostgreSQL. SUMMARY:Building PetaByte Warehouses with Unmodified PostgreSQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT0H30M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/199.en.html DTSTART;TZID=America/Montreal:20090522T173000 UID:199@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:The Traditional Closing Session SUMMARY:Closing sessions - prizes\, auctions\, fun\, games STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/129.en.html DTSTART;TZID=America/Montreal:20090522T113000 UID:129@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:The Wisconsin State Courts converted their databases\, physical ly located at 72 county circuit court sites\, as well several central sites \, to PostgreSQL in a very short time without major problems. All county s ervers were converted over the course of a few months. SUMMARY:Converting 100 databases to PostgreSQL - Wisconsin State Courts imp lementation STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/152.en.html DTSTART;TZID=America/Montreal:20090521T133000 UID:152@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:PostgreSQL DBAs and hardware vendors seem like they're speaking different languages some days. Doing your own low-level hardware benchma rking can provide the secret decoder ring needed to translate all the way f rom database transactions to disk commits. SUMMARY:Database Hardware Benchmarking - How big is the elephant in your ro om? STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/155.en.html DTSTART;TZID=America/Montreal:20090522T133000 UID:155@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Most DBA's have areas of the databases that they manage that th ey would like to change. However\, very few are actually given the liberty \, resources\, and time to make these changes due to the impact it would ha ve on the existing system's code and the impact on the customers. What if there were a way to get around these obstacles and make the structure chang es you want and need without requiring an application rewrite? SUMMARY:Database Refactoring - An idea on how to redesign an existing datab ase with minimal downtime STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/120.en.html DTSTART;TZID=America/Montreal:20090521T113000 UID:120@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Need to store or access your PostgreSQL data with extra confide ntiality? This talk will look at the options available for data and transpo rt encryption in PostgreSQL. SUMMARY:Encrypted PostgreSQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/178.en.html DTSTART;TZID=America/Montreal:20090522T100000 UID:178@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:This talk will cover the intricacies of getting your patch acce pted by the PostgreSQL community and included in the next software release. SUMMARY:How to Get Your PostgreSQL Patch Accepted - patch submission accept ed STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/128.en.html DTSTART;TZID=America/Montreal:20090521T160000 UID:128@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:PostgreSQL 8.4 has much of the functionality of SQL:2008 window ing functions.In this presentation\, you'll learn what windowing functions are for\, how theywork\, both from the end-user and the RDBMS implementatio n perspective\, andplans for future enhancements. You will also learn how to createuser-defined windowing functions in C. SUMMARY:Introducing Windowing Functions - Internals and Externals STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/118.en.html DTSTART;TZID=America/Montreal:20090522T150000 UID:118@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Learn about Golconde\, a queue-based data distribution system d eveloped at myYearbook.com. In implementing data distribution via external message queues\, Golconde differentiates itself from traditional PostgreSQ L replication tools\, moving the workload for replication management outsid e of PostgreSQL itself. We will review the design decisions that resulted in Golconde as well as see it in action. SUMMARY:Introduction to Golconde - Golconde is a queue-based data distribut ion system STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/181.en.html DTSTART;TZID=America/Montreal:20090522T150000 UID:181@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Introduction to new 8.4 feature "WITH RECURSIVE" with examples of querying recursive database data structures such as trees or graphs. SUMMARY:Introduction to Recursive Queries - Recursion: see recursion STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/185.en.html DTSTART;TZID=America/Montreal:20090522T163000 UID:185@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Lightning talks - details to follow SUMMARY:Lightning talks - Short sharp descriptions of short topics STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/179.en.html DTSTART;TZID=America/Montreal:20090521T100000 UID:179@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Another year\, another PostgreSQL release\, and once again this release packed full of new features that will help you whether you develop apps inside or outside the database\, or you just need to keep them runnin g. This talk will give an overview of the new features available in 8.4\, a nd give you pointers to talks during the rest of the conference you'll want to focus on to get the most out of 8.4. SUMMARY:No More Waiting - A Guide To PostgreSQL 8.4 STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/141.en.html DTSTART;TZID=America/Montreal:20090521T143000 UID:141@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:The OpenStreetMap project is trying to build a free (as in beer ) editable electronic map of the world. Data is collected by ordinary peopl e running around with GPS units\, tracing imagery and by integrating existi ng datasets. This talk will an introduction to OpenStreetMap and an overvie w of how the OpenStreetMap data can be used with PostgreSQL/PostGIS. SUMMARY:OpenStreetMap with PostgreSQL - The free wiki world map & PostgreSQ L STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT0H30M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/197.en.html DTSTART;TZID=America/Montreal:20090521T093000 UID:197@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Welcome to PGCon 2009 SUMMARY:Opening Session - Welcome STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H30M LOCATION:The Velvet Room SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/198.en.html DTSTART;TZID=America/Montreal:20090521T190000 UID:198@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:The PGCon 2009 dinner. SUMMARY:PGCon 2009 dinner - sponsored by EnterpriseDB STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/188.en.html DTSTART;TZID=America/Montreal:20090519T130000 UID:188@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:"The database is slow!" How often you've heard that plaintive cry from your co-workers\, customers or client. In this tutorial\, Josh Be rkus will explain his simple methodology for resolving database application performance problems. He'll also demonstrate some of the OS and PostgreSQ L tools available for troubleshooting performance problems and show how to use them. SUMMARY:Performance Whack-a-Mole II - The Moles Are Back\, and Bigger Than Ever STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/158.en.html DTSTART;TZID=America/Montreal:20090521T133000 UID:158@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Post Facto is an open-source version control system for Postgre SQL databases. Unlike traditional VC tools\, which operate on filesystems\, Post Facto operates directly on databases\, easing the management of multi ple schema versions. SUMMARY:Post Facto\, version control for PostgreSQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/124.en.html DTSTART;TZID=America/Montreal:20090521T143000 UID:124@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:PostgreSQL 8.4beta will be released on February 2009. We do a q uick analysis of how PostgreSQL 8.4B compares to the released 8.3.x product using various workloads and other opensource products SUMMARY:PostgreSQL 8.4Beta Vs PostgreSQL 8.3 - A view from the Performance world STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/132.en.html DTSTART;TZID=America/Montreal:20090519T090000 UID:132@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:PostgreSQL offers many options for controlling access\, from au thentication and log in to the role system and finally the hierarchy of aut horization to specific resources. System Administrators and Database Admin istrators need to understand these complexities to ensure their system is b oth robust and secure. With 8.4 there have been many changes to existing o ptions (Kerberos mapping support\, finally!) as well as whole new capabilit ies (column-level privileges\, TRUNCATE privilege!). We will go through al l of the authentication options that PostgreSQL offers\, followed by how to integrate with existing single-sign-on and other infrastructure (Kerberos\ , LDAP)\, then walk through setting up roles following best practices and p rivilege separation\, and finally go through the privilege system from data base-level down to column-level. SUMMARY:PostgreSQL Access Controls (AuthN\, AuthZ\, Perms) - Controlling Ac cess to your database- Roles\; Kerberos\, LDAP integration\; Database\, Sch ema\, Table\, and Column-level(!) permissions STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/195.en.html DTSTART;TZID=America/Montreal:20090521T180000 UID:195@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Come gather with your fellow testing fanatics to share thelates t tips and tricks for testing your database. SUMMARY:PostgreSQL Unit Testing - A BOF STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/151.en.html DTSTART;TZID=America/Montreal:20090522T133000 UID:151@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:PostgreSQL has had support for storage of temporal data\, inclu ding a "time travel" capability\, since even before it was called PostgreSQ L\, and PostgreSQL offers a fairly good set of operators to work on tempora l data\, at least when comparing with SQL standards.This talk describes sev eral of the ways that PostgreSQL may be used to record temporal data\, alon g with advantages and disadvantages. SUMMARY:PostgreSQL and Temporal Data STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/167.en.html DTSTART;TZID=America/Montreal:20090521T170000 UID:167@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Covering everything there is to know about psql\, the best data base command-line utility in existence. Learn tipsand tricks to make your s essions more productive and make your coworkers envious. SUMMARY:Power psql - All about everyone's favorite utility STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/122.en.html DTSTART;TZID=America/Montreal:20090522T113000 UID:122@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:So\, you've solved all of your current performance problems\, b ut are you ready for tomorrow? Suppose your website traffic increases thre e-fold\, or your company has a huge end-of-year processing job to run\, at what point will your system become unusable? In this case\, is it a CPU pr oblem\, I/O problem\, or both? Should you add additional CPUs or can you j ust get faster CPUs? How fast does your I/O subsystem need to be in order to handle your workload? How much would query tuning help? This session i s designed to help you answer those questions. SUMMARY:Predicting Postgres Performance - Practical Queueing Theory for Pos tgres DBAs STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT5H00M LOCATION:Royal Oak SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/192.en.html DTSTART;TZID=America/Montreal:20090522T180000 UID:192@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:The last big social event... SUMMARY:Pub Night! - Last chance for social intercourse before the Touristy stuff tomorrow STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/146.en.html DTSTART;TZID=America/Montreal:20090522T100000 UID:146@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:The Millburn Corporation is a hedge fund which uses complex dat a-driven trading models based on the daily prices of various commodities\, currencies and other inputs. As part of our application development process \, we use independent stage and test instances of our production database t o let us have a smoother and less mistake-prone deployment of new models an d price streams. In this talk\, I will discuss our setup\, which makes heav y use of schemas\, Slony\, DBI-link\, pgTAP and custom deployment tools in order to compare and reconcile data across databases. SUMMARY:Reconciling and comparing databases - Using schemas\, Slony\, DBI-l ink\, pgTAP and other tools to compare different databases STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H00M LOCATION:Royal Oak SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/190.en.html DTSTART;TZID=America/Montreal:20090520T150000 UID:190@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 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 1150 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/142.en.html DTSTART;TZID=America/Montreal:20090522T133000 UID:142@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:SQL/MED is Management of External Data\, a part of the SQL stan dard that deals with how a database management system can integrate data st ored outside thedatabase. The implementation of this specification has beg un in PostgreSQL 8.4 and will over time introduce powerful new features int o PostgreSQL. SUMMARY:SQL/MED - Doping for PostgreSQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/149.en.html DTSTART;TZID=America/Montreal:20090521T113000 UID:149@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Spatial databases are different from other databases through it s requirement to store spatial data features\, capable of describing its lo cation on space and representation. Its highlighted in the projects the uti lization of PostgreSQL with PostGIS. During this lecture it will be discuss ed the use of the aforementioned tools in the management of spatial databas e\, and the application of spatial analysis techniques on data stored in en vironmental database. SUMMARY:Saving the Amazon with PostGIS - Spatial Manipulation in the Rain F orest STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/134.en.html DTSTART;TZID=America/Montreal:20090521T170000 UID:134@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Replication tool in SkyTools package code named Londiste. Gener al overview of Londiste. Whats new in version 3. SUMMARY:SkyTools3: Replication (Londiste3) - Overview of Londiste and what' s new in version 3 STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/138.en.html DTSTART;TZID=America/Montreal:20090520T090000 UID:138@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:An introduction into PgQ and SkyTools - efficient queue impleme ntation on top ofPostgreSQL and the tools to manage it. Description of PgQ\ , the different kindsof consumers\, queue applications and their usage scen arios and how to tie it alltogether with SkyTools. SUMMARY:SkyTools: Queues (PgQ) STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/194.en.html DTSTART;TZID=America/Montreal:20090521T180000 UID:194@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Solid State Drives are the biggest change in storage technology since the hard drive was invented in the 1950s. SUMMARY:Solid State Drives - A BOF STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/119.en.html DTSTART;TZID=America/Montreal:20090521T100000 UID:119@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:We will present some recent improvements in full-text search\, we developed during 8.4 development stage and after. SUMMARY:Some recent advances in full-text search STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/174.en.html DTSTART;TZID=America/Montreal:20090521T160000 UID:174@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:In this lecture we shall describe some use cases of PostGIS -- a brief overview of how it is used in various ways such as for location awa re applications\, property management\, and environmental risk assessment. SUMMARY:Spatial Analysis with PostGIS STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/143.en.html DTSTART;TZID=America/Montreal:20090521T160000 UID:143@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:A survey of current and emerging development practices in open- source projects\, and ideas that the PostgreSQL project could pick up. SUMMARY:The Lives of Others - Open-Source Development Practices Elsewhere STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/176.en.html DTSTART;TZID=America/Montreal:20090522T150000 UID:176@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:FluidDB is a hosted database that Fluidinfo (http://fluidinfo.c om) willlaunch in alpha early this year. In this talk I will describe: the aspectsof FluidDB that make it novel\, the reasoning behind this approach t oworking with data\, and the architecture of FluidDB. The system iscurrent ly deployed on top of Amazon EC2 and S3\, and we are using PostgreSQLas a k ey component in the architecture. SUMMARY:The design\, architecture\, and tradeoffs of FluidDB - The database with the heart of a wiki. STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT4H00M LOCATION:Out and about SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/191.en.html DTSTART;TZID=America/Montreal:20090523T100000 UID:191@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Play Tourist SUMMARY:Tourist Time - See the sights in and/or around Ottawa STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/165.en.html DTSTART;TZID=America/Montreal:20090521T143000 UID:165@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Given that the database\, as the canonical repository of data\, is the most important part of many applications\, why is it that we don't write database unit tests? This talk promotes the practice of implementing tests to directly test the schema\, storage\, and functionality of database s. SUMMARY:Unit Test Your Database! - Use a flexible database unit testing fra mework to assure database integrity and functionality STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/189.en.html DTSTART;TZID=America/Montreal:20090521T170000 UID:189@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:By version 8.5\, most of the major issues affecting PostgreSQL usability and adoption will be fixed. Except upgrading. Join our round-ta ble of PostgreSQL hackers to discuss the project's plans to make upgrading PostgreSQL less painful. SUMMARY:Upgrade Melee - A free-for-all on PostgreSQL's biggest remaining pr oblem STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/184.en.html DTSTART;TZID=America/Montreal:20090522T113000 UID:184@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:VACUUM is a an important topic for new and seasoned users of Po stgres. This talk will focus on changes in Postgres from version 8.0 on\, h ow to bast take advantage of configuration parameters related to VACUUM\, a utovacuum\, the updated Free Space Map in 8.4\, and the brand new Visibilit y Map. SUMMARY:VACUUM Strategy - Autovacuum\, FSM\, Visibility Map STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/153.en.html DTSTART;TZID=America/Montreal:20090521T113000 UID:153@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Postgres provides a variety of metrics that are available via S QL queries. Much of this useful data is transient. By tracking these metric s over time\, database\, relation\, and index trends can be easily visualiz ed using simple graphs and charts\, which in turn can be used to assess cur rent server performance\, assist in tuning\, diagnose performance issues\, and anticipate potential future issues. An application for such tracking an d visualization will be presented. SUMMARY:Visualizing Postgres STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/159.en.html DTSTART;TZID=America/Montreal:20090520T130000 UID:159@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:PostgreSQL allows development in many different programming lan guages\, to suit the tastes of each aspiring hacker. Learn how to write a P ostgreSQL procedural language\, using one of the latest\, and certainly the least\, of these languages\, PL/LOLCODE. SUMMARY:Writing a Procedural Language - I CAN HAZ P.L.Z PLZ? STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2009/schedule/events/154.en.html DTSTART;TZID=America/Montreal:20090521T133000 UID:154@PGCon2009@pentabarf.org DTSTAMP:20100813T023628 CATEGORIES:Lecture DESCRIPTION:Similarity query is a fundamental operation in many application areas\, such as data integration and cleaning\, bioinformatics\, and patte rn recognition. pg_similarity is a tool that makes available user-friendly methods such as functions and operators for similarity queries. More than a dozen of functions are currently available. SUMMARY:pg_similarity - Functions and Operators for Executing Similarity Qu eries STATUS:CONFIRMED END:VEVENT END:VCALENDAR