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/2010/schedule/events/224.en.html DTSTART;TZID=America/Montreal:20100521T133000 UID:224@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Hi-Media online services all run atop PostgreSQL\, and use some form of replication. This talk will present what problems we solve with re plication\, and how. SUMMARY:2 years of londiste - PostgreSQL usage at Hi-Media STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/259.en.html DTSTART;TZID=America/Montreal:20100520T100000 UID:259@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Discussing why integrating application authorization with your database is a good idea\, downsides to such integration\, implementation go tchas\, and finally covering an example implementation. SUMMARY:Application-level Authorization via SET ROLE - Working around conn ection pooling for permissions STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/264.en.html DTSTART;TZID=America/Montreal:20100520T100000 UID:264@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:An introduction to the new built-in replication features in Pos tgreSQL 9.0\, Hot Standby and Streaming Replication. SUMMARY:Built-in replication in PostgreSQL 9.0 STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/257.en.html DTSTART;TZID=America/Montreal:20100521T133000 UID:257@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Compared to many proprietary systems\, Postgres tends to be pre tty straight forward to run. However\, if you want to get the most from you r database\, you shouldn't just set it and forget it\, you need to monitor a few key pieces of information to keep performance going. This talk will r eview several key metrics you should be aware of\, and explain under which scenarios you may need additional monitoring. SUMMARY:Check Please! - What Your Postgres Databases Wishes You Would Monit or STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT0H30M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/247.en.html DTSTART;TZID=America/Montreal:20100521T173000 UID:247@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:The Traditional Closing Session SUMMARY:Closing sessions - prizes\, auctions\, fun\, games STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT2H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/270.en.html DTSTART;TZID=America/Montreal:20100521T180000 UID:270@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Anyone interested in working on clustering solutions to Postgre SQLplease attend this BOF. SUMMARY:Cluster-Hackers BOF - cluster like you mean it STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/227.en.html DTSTART;TZID=America/Montreal:20100520T113000 UID:227@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:We present implementation of new GiST tree traverse strategy a nd efficient k-nn search based on this strategy. Also\, we'd like to discus s new signature file based index (bloom index)\, it's implementation and po ssible improvements. SUMMARY:Efficient k-nn search with GiST and other development STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/205.en.html DTSTART;TZID=America/Montreal:20100520T133000 UID:205@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:User-defined functions are one of the easiest ways to get start ed hacking on the PostgreSQL codebase and produce something useful in a sho rt time. Watch a whole new trivial feature get added with one\, and learn how to step over some of the more common confusing parts of the codebase al ong the way. SUMMARY:Exposing PostgreSQL Internals with User-Defined Functions - Easing into PostgreSQL Hacking STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/234.en.html DTSTART;TZID=America/Montreal:20100520T150000 UID:234@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:A look at some of the typical symptoms of corrupted databases\, the usual culprits which cause problems\, and a survey of strategies for c orrecting problems. SUMMARY:Forensic Analysis of Corrupted Databases - What to do when things r eally hit the fan STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/233.en.html DTSTART;TZID=America/Montreal:20100520T113000 UID:233@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:We propose to add hypothetical (or virtual) indexes in order to offer both what-if querying and automatic index tuning. SUMMARY:Hypothetical Indexes towards self-tuning in PostgreSQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/217.en.html DTSTART;TZID=America/Montreal:20100520T150000 UID:217@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Nowadays\, many web applications are closely combined with data base systems\, using the database to provide various kinds of dynamic conte nt. In these environments\, you cannot just focus on individual application s\, databases and the operating systems. You need to consider the whole sys tem.This session describes why you should apply consistent and centralized access control policy\, how SE-PostgreSQL can be utilized to improve web ap plication security\, and shows a working example of the stack named as LAPP /SELinux. SUMMARY:LAPP/SELinux - A secure web-application stack using SE-PostgreSQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/267.en.html DTSTART;TZID=America/Montreal:20100520T173000 UID:267@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 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:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/218.en.html DTSTART;TZID=America/Montreal:20100521T113000 UID:218@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:When you give your database server memory\, you expect it's goi ng to use it. But for what? A look inside PostgreSQL's buffer cache can t ell you exactly what that memory is doing for you. Every systematic databa se tuning effort should include a look at this critical resource. When it comes to optimization work\, profiling beats guessing every time. SUMMARY:Monitoring PostgreSQL Buffer Cache Internals - Watching disk cachin g inside the database STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/202.en.html DTSTART;TZID=America/Montreal:20100518T090000 UID:202@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Another year\, another PostgreSQL release\, and once again this release packed full of new features. This talk will give an overview of th e new features available in 8.5\, and give you pointers to talks during the rest of the conference you'll want to focus on to get the most out of 8.5. Whether you develop apps inside or outside of the database\, or you're th e one who has to keep them running\, this should be your first stop on the road to 8.5. SUMMARY:No More Waiting - A Guide To PostgreSQL 9.0 STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/201.en.html DTSTART;TZID=America/Montreal:20100520T133000 UID:201@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:UNIQUE is no longer unique among constraints. I authored "Exclu sion Constraints" for PostgreSQL 8.5: a more general constraint mechanism t hat can enforce constraints such as "non-overlapping" as well as unique\; a nd can enforce constraints on GiST or hash indexes as well as BTree. See wh y other constraint mechanisms are unsuitable for common business requiremen ts -- like handling schedule conflicts -- and how the problems are solved b y using Exclusion Constraints. SUMMARY:Not Just UNIQUE - Exclusion Constraints STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/274.en.html DTSTART;TZID=America/Montreal:20100521T100000 UID:274@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Enova Financial provides online financial services to under-ser ved consumers in the United States\, Great Britain\, Australia and Canada. SUMMARY:Online financial services & Postgres - Staking our claim on open so urce technologies STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H30M LOCATION:The Velvet Room SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/273.en.html DTSTART;TZID=America/Montreal:20100520T190000 UID:273@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Come and join us for the major social event of PGCon 2010 SUMMARY:PGCon 2010 Major Social Event! - sponsored by EnterpriseDB STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/200.en.html DTSTART;TZID=America/Montreal:20100521T100000 UID:200@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Calling functions written in one PL from another shouldn't be p ainful\, and with PL/Parrot\, it won't be. SUMMARY:PL/Parrot - Yep\, there's actually code now! STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/207.en.html DTSTART;TZID=America/Montreal:20100521T163000 UID:207@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Find out all you need to know about the new PL/Perl features in PostgreSQL 9.0 SUMMARY:PL/Perl - new features in 9.0 STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/219.en.html DTSTART;TZID=America/Montreal:20100520T090000 UID:219@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:The NoSQL movement has captured the attention of many web devel opers\, often times using the myth that SQL databases like PostgreSQL do no t scale as well as newer technologies. We wil examine many of the more pop ular key/value store databases and illustrate the pros and cons of using a "NoSQL" database\, examining the features of the more popular NoSQL alterna tives in comparison to PostgreSQL. More importantly\, we will address the impact of NoSQL technology at scale as it compares to PostgreSQL and ultima tely discover why PostgreSQL is the YesQL alternative to today's upstart da tabase technologies. SUMMARY:Perspectives on NoSQL - What NoSQL means to PostgreSQL and why Post greSQL is YesQL. STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/261.en.html DTSTART;TZID=America/Montreal:20100520T150000 UID:261@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:While PostgreSQL can see the contents of shared buffers\, it do es not know about the OS page cache\, which in turn tells which pages are a ctually in memory. PgFincore provides this information\, which allows us t o:- Preload the exact pages that PostgreSQL will probably want in order to respond more quickly to the first queries on server restart.- Try to improv e planner choice and cost estimation.It suggest ideas to :- Keep pg_dump fr om trashing the OS Page Cache- Explicitly ask for a non-cached sequential s can.PgFincore also provides information about how the data in the OS page c ache is distributed. SUMMARY:PgFincore and the OS Page Cache - Is my table in memory ? STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/251.en.html DTSTART;TZID=America/Montreal:20100521T100000 UID:251@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Embedded Messaging with PgMQ\, the PostgreSQL Message Queueing add-onPgMQ embeds messaging directly into PostgreSQL so that committed tran sactions can be published to message queues via various popular messaging p rotocols (AMQP\, STOMP\, OpenWire). Supports ActiveMQ (STOMP\, OpenWire) a nd any transport supporting AMQP (such as RabbitMQ). PgMQ easily enables " eventually consistent" replication and/or sharding along customized data bo undaries. PgMQ also introduces an index extension that enhances temporal da ta types (timestamp\, date\, etc.) by firing an event (trigger) when the va lue is equal to current_time\, an aid to replication and partitioning. This lecture will show how to set up and configure PGMQ\, with realtime example s. SUMMARY:PgMQ - PgMQ: Embedding messaging in PostgreSQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/242.en.html DTSTART;TZID=America/Montreal:20100519T130000 UID:242@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:An introduction and thorough review of access control in Postgr eSQL. All access control will be covered\, but special attention will be pa id to new features and changes in 8.5. This will include both System Admin configuration specifics (hba.conf) and Database Admin permissions (GRANT s ystem). SUMMARY:PostgreSQL Access Controls (AuthN\, AuthZ\, Perms) - Controlling Ac cess to your database- Roles\; Kerberos\, LDAP\, SSL\, RADIUS(!)\; Database Permissions STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/210.en.html DTSTART;TZID=America/Montreal:20100521T113000 UID:210@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:This session will cover lessons learned about Ruby on Rails dev elopment using PostgreSQL. From the database-centric view the session will explain Rails best practices\, taking advantage of RoR strong points\, deal ing with its weak points\, PostgreSQL strong and weak points\, and using ad vanced SQL features in web applications. The session will demonstrate how P ostgreSQL is used to speedup Rails code\, making slow things in your web ap plication fast and impossible things - possible. The session will also disc uss the peculiarities of complex enterprise apps and show that PostgreSQL i s an ideal open source match for their development. SUMMARY:PostgreSQL as a secret weapon for high-performance Ruby on Rails ap plications STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/204.en.html DTSTART;TZID=America/Montreal:20100520T113000 UID:204@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Case study of PostgreSQL in the project "Multicanal" of the bra zilian government bank Caixa Economica Federal - the day-to-day activities\ , challenges\, solutions proposed and approved\, high availability and high performance in the world's unique Free Software case in this type of publi c institution. SUMMARY:PostgreSQL in Mission-Critical Financial Systems - Case study of Po stgreSQL in the Multicanal project of the brazilian bank Caixa Economica Fe deral STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/238.en.html DTSTART;TZID=America/Montreal:20100520T100000 UID:238@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Experience in one database system does not always make learning another one easy. Although Postgresis more SQL-compliant than just about a nything else\, there are plenty of quirks\, features\, andgotchas that you should be aware of. SUMMARY:Postgres for non-Postgres people - Getting to know the Postgres way STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/226.en.html DTSTART;TZID=America/Montreal:20100521T163000 UID:226@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:We will present a new PostgreSQL cluster called Postgres-XC (Ex tensible Cluster) developed by NTT and EnterpriseDB. Postgres-XC's perfor mance is write-scalable. It also provides synchronous multi-master capabil ity. Updates through one master are visible from any other masters immedia tely after the commit. SUMMARY:Postgres-XC\, Write-scalable\, synchronous multi-master PostgreSQL cluster with shared nothing approach STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/220.en.html DTSTART;TZID=America/Montreal:20100521T133000 UID:220@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Operating system developments in recent years have provided adm inistrators with new and powerful ways of peeking into live\, production ap plications to investigate behaviors and solve problems in real time without significant system impact. PostgreSQL provides several probe points allowi ng these dynamic tracing tools access to running applications that was form erly available only with a debugger. In this discussion we will explore the DTrace and SystemTap applications and some of their capabilities\, with sp ecific focus on PostgreSQL. SUMMARY:Probing PostgreSQL with DTrace and SystemTap STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT5H00M LOCATION:Royal Oak SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/246.en.html DTSTART;TZID=America/Montreal:20100521T183000 UID:246@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 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:PT3H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/213.en.html DTSTART;TZID=America/Montreal:20100519T090000 UID:213@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Applications and databases need testing. But how can you get va lid results for a fully integrated system Flight-Check test at realistic lo ads? This tutorial addresses the many challenges that arise in an applicati on or database development to give confidence to you and your customers in presenting a production-ready product. SUMMARY:Realistic Load Testing - HOWTO set up a realistic testing environme nt using PostgreSQL Functions and Python STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/244.en.html DTSTART;TZID=America/Montreal:20100521T150000 UID:244@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 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 staging and development instances of our production d atabase to let us have a smoother and less mistake-prone deployment of new models and price streams.Last year\, I presented a talk at PgCon 2009 that examined in broad detail how we make heavy use of different schemas to comp are and reconcile data between our different environments. In this talk\, I 'll examine in detail our attempt to solve a problem we face in our databas e environment: how to test complex triggers and functions before they're de ployed\; and how to reconcile and track changes in these functions as they move from our development to our staging and production environments. Speci fically\, I'll describe how we make use of subversion\, pg_dump and pgTAP t o roll trigger and function changes to our development environment nightly\ ; and how we test the integrity of the functions and trigger functions on o ur staging and production environments nightly using pgTAP. SUMMARY:Reconciling and comparing databases redux - Deploying and testing t riggers and functions in multiple databases STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H30M LOCATION:Royal Oak SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/266.en.html DTSTART;TZID=America/Montreal:20100519T150000 UID:266@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 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/2010/schedule/events/211.en.html DTSTART;TZID=America/Montreal:20100521T150000 UID:211@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Finding the optimal join order for an arbitrary number of relat ions is an NP-hard problem. For small queries applying exhaustive search is feasible\, but the runtime and memory consumption make that approach impra ctical in many real-life applications.PostgreSQL's answer to that problem i s GEQO: the genetic query optimizer. It employs heuristics similar to those commonly used for solving the Travelling Salesman Problem. However\, recen t studies suggest other randomized algorithms could yield better results in shorter time.One such approach\, called Simulated Annealing\, will be pres ented\, along with a prototype implementation that you can load and try aga inst your most monstrous queries. SUMMARY:Replacing GEQO - Join ordering via Simulated Annealing STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/268.en.html DTSTART;TZID=America/Montreal:20100521T113000 UID:268@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION: SUMMARY:Replication Panel STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/231.en.html DTSTART;TZID=America/Montreal:20100521T150000 UID:231@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:PostgreSQL supports several options for securing communications and access when deployed outside the typical webserver/database combinatio n. This talk will discuss the features that make this possible\, with some extra focus on the changes in 8.4 and 8.5. SUMMARY:Secure PostgreSQL Deployment STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT3H00M LOCATION:DMS 1110 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/223.en.html DTSTART;TZID=America/Montreal:20100518T130000 UID:223@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Have you given your PostgreSQL database server a checkup lately ? If not\, you probably should. "Sick" database servers are easy to preve nt if you take a few simple steps before your server comes down with something. SUMMARY:Server Health Check - Give your Postgres server a checkup STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT2H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/271.en.html DTSTART;TZID=America/Montreal:20100521T180000 UID:271@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Calling all database testers! SUMMARY:Testing BOF - Testing your database STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1160 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/228.en.html DTSTART;TZID=America/Montreal:20100520T163000 UID:228@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Users of proprietary database management systems are usually bo und touse graphical modeling tools with an emphasis on drawing diagrams and generating SQL DDL code from them. The process is generallyerror-prone and cumbersome\, being based on mediochre user interfacesand generating bad SQ L representing poor data models\, as diagrams canhardly represent the full richness of SQL data models — specially inan SQL flavor like PostgreSQL’s. Many databases arereverse-engineered into entity-relationship diagrams\, l oosing muchinformation coded into SQL features not directly supported by th ediagramming tools\, or in the SQL DDL source code which originallycreated the reverse-engineered database.A well-kept but open secret of many databas e administrators isreliance on source code and automatic diagramming tools. Breakingfree from the misconception that all information should be graphi callyrepresented\, or even that it should be graphically created\, and from the mistaken identification of modeling and drawing\, such datamodelers are free to use the full power of both SQL and theirwell-proven\, flexible sou rce code tools\, all the while generating allthe graphics and web pages the y could possibly want automatically\,using simple\, fast programs which can lay out diagrams much betterthan most drafters.SQL DDL coding can also be nicely combined to literary programmingtools\, in what we call ‘literary mo deling’: interspersing SQL DDLstatements in a full text explanation of the model and the reasoningbehind it\, we can generate both text files for data base schemacreation\, and nicely formatted documents for reading\, browsing andreference\, both printed and online. These documents can\, andtypicall y will\, include graphics generated automatically from eitherthe SQL DDL or the database schema itself.It is our tested conviction that this process i s much more pleasurableand efficient than the tradicional diagram-based one . SUMMARY:The Illustrated Elephant - Literary modeling and automatic document ation in PostgreSQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1150 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/208.en.html DTSTART;TZID=America/Montreal:20100520T163000 UID:208@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Why does my query need a plan? Sequential scan vs. index scan. Join strategies. Join reordering. Using EXPLAIN. Row count and cost es timation. SUMMARY:The PostgreSQL Query Planner STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/235.en.html DTSTART;TZID=America/Montreal:20100520T163000 UID:235@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:ORMs (Object-to-Relational Mapping) are a must for programmers\ , while they are usually a nightmare for DBAs. At the same time\, they are large and complex\, and underpowered -compared to the database itself-. It' s time to rethink ORMs\, and let programmers receive input from the databas e community in a new strategy of collaboration where a new interface (say " API") between both is designed. SUMMARY:To ORM or not to ORM (that's the question) - Exploring both DBA's a nd programmers point-of-view STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT5H00M LOCATION:Out and about SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/272.en.html DTSTART;TZID=America/Montreal:20100522T093000 UID:272@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Explore Ottawa SUMMARY:Tourist stuff - Spend some time exploring STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/258.en.html DTSTART;TZID=America/Montreal:20100521T163000 UID:258@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:The talk will explore using Git to work with PostgreSQL in vari ous roles\, including: tester\, reviewer\, developer\, committer and buildf arm owner. SUMMARY:Using Git to work with PostgreSQL STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT2H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/269.en.html DTSTART;TZID=America/Montreal:20100521T180000 UID:269@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:Postgres has grown to the point where it is very difficult to a dd missing features without financial support from commercial users and coo peration between companies providing Postgres support as well as general co mmunity members. SUMMARY:We have money\, do you have the time? - How commercial companies ca n fund Postgres development. STATUS:CONFIRMED END:VEVENT BEGIN:VEVENT DURATION:PT1H00M LOCATION:DMS 1140 SEQUENCE:0 URL:http://www.pgcon.org/2010/schedule/events/216.en.html DTSTART;TZID=America/Montreal:20100520T133000 UID:216@PGCon2010@pentabarf.org DTSTAMP:20100813T024122 CATEGORIES:Lecture DESCRIPTION:NTT has developed "pg_statsinfo"\, that collects database activ ities and statisticsautomatically\, and shows the information to DBAs in us er-friendly shapes.Also pg_statsinfo can collect statistics from multiple D Bs\, so this tool makesit much easier to monitor the status of many DB serv ers SUMMARY:pg_statsinfo - More useful statistics information for DBAs STATUS:CONFIRMED END:VEVENT END:VCALENDAR