2.0 -//Pentabarf//Schedule #<Conference_release::Row:0x80925f0b0>//EN PGCon2013 Schedule Release #<Conference_release::Row:0x80925f0b0> PGCon2013 Schedule PUBLISH 615@PGCon2013@pentabarf.org 615 Agile Database Development with Git, Sqitch, and pgTAP English en 20130522T130000 20130522T160000 03H00M00S Agile Database Development- with Git, Sqitch, and pgTAP Hi, I'm David. I like to write database apps. Just as much as I like to write web apps. (Maybe more!) How? Not by relying on bolted-on, half-baked database integration tools like migrations, I'll tell you that!. Instead, I make extensive use of best-of-breed tools for source control ([Git](http://git-scm.org/), database unit testing ([pgTAP](http://pgtap.org/)), and database change management and deployment ([Sqitch](http://sqitch.org/)). If you'd like to get as much pleasure out of database development as you do application development, join me for this tutorial. We'll develop a sample application using the processes and tools I've come to depend on, and you'll find out whether they might work for you. Either way, I promise it will at least be an amusing use of your time. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/615.en.html MRT 256 David E. Wheeler PUBLISH 535@PGCon2013@pentabarf.org 535 Automated PostgreSQL Scaling on AWS Managing Your Thundering Herd English en 20130524T163000 20130524T173000 01H00M00S Automated PostgreSQL Scaling on AWS- Managing Your Thundering Herd Amazon Web Services provides tremendous tools and techniques for scaling services up and down in response to planned or experienced load. However, too many systems are configured to use AWS as an equipment-rental facility, which wastes money and does not take advantage of AWS' unique properties. We'll talk about how to build systems that flex-scale using AWS tools. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/535.en.html MRT 256 Christophe Pettus PUBLISH 623@PGCon2013@pentabarf.org 623 Closing sessions prizes, auctions, fun, games English en 20130524T173000 20130524T183000 01H00M00S Closing sessions- prizes, auctions, fun, games The Traditional Closing Session PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/623.en.html MNT 202 Dan Langille PUBLISH 586@PGCon2013@pentabarf.org 586 Corruption Detection and Containment Strategies and Roadmap English en 20130523T113000 20130523T123000 01H00M00S Corruption Detection and Containment- Strategies and Roadmap This will not be the most exciting talk, nor is there (currently) a simple answer to make hardware corruption problems go away. But it's important -- without being careful, it's easy for corruption to spread to replicas and backups, leaving data hopelessly lost. Or, a strange crash due to corruption could take many engineering resources to analyze. This talk is about kinds of hardware corruption that can and do happen, and the ways to detect and contain the corruption as quickly as possible. Additionally, we'll discuss a roadmap of improvements to postgresql to make this an easier process; as well as alternatives (such as detecting corruption in the filesystem). Note: Some storage systems do provide strong protections against data corruption. This talk is primarily (though not exclusively) targeted at users of the local filesystem, particularly on Linux. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/586.en.html MNT 202 Jeff Davis PUBLISH 607@PGCon2013@pentabarf.org 607 Data Processing Inside PostgreSQL English en 20130521T090000 20130521T120000 03H00M00S Data Processing Inside PostgreSQL This talk is best for those who are are familiar with databases and SQL, but want to learn how to move processing from their applications into the database to improve consistency, administration, and performance. Topics covered include advanced SQL features like referential integrity constraints, ANSI joins, views, rules, and triggers. The presentation also explains how to create server-side functions, operators, and custom data types in PostgreSQL. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/607.en.html MRT 256 Bruce Momjian PUBLISH 540@PGCon2013@pentabarf.org 540 Elephant Puppets Deployment automation for PostgreSQL English en 20130524T113000 20130524T123000 01H00M00S Elephant Puppets- Deployment automation for PostgreSQL Puppet is a platform for I.T. automation and configuration management that has gained popularity in the devops movement. This talk will provide an introduction to puppet and talk about how Afilias uses puppet to deploy and maintain over one hundred servers running PostgreSQL that support key parts of the DNS infrastructure PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/540.en.html MRT 256 Steve Singer PUBLISH 576@PGCon2013@pentabarf.org 576 Estimating query progress Theory and practice of query progress indication English en 20130524T150000 20130524T160000 01H00M00S Estimating query progress- Theory and practice of query progress indication Your query has been running for 70 hours. Should you kill it now or ignore angry calls for a few more hours and hope it returns the result? A question many a DBA have asked themselves. This talk will try to cover some of the techniques the database system could use in order to make decisions like that easier. We'll describe an approach based on existing research papers and report on the attempt of implementing it in a useful way inside PostgreSQL. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/576.en.html MRT 221 Jan Urbański PUBLISH 624@PGCon2013@pentabarf.org 624 hacker3 Hacker Lounge meet, greet, code, slack English en 20130524T190000 20130525T000000 05H00M00S Hacker Lounge- meet, greet, code, slack A place to gather... PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/624.en.html L140 Dan Langille PUBLISH 636@PGCon2013@pentabarf.org 636 hacker2 Hacker Lounge meet, greet, code, slack English en 20130521T190000 20130522T000000 05H00M00S Hacker Lounge- meet, greet, code, slack A place to gather... PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/636.en.html L140 Dan Langille PUBLISH 618@PGCon2013@pentabarf.org 618 hacker1 Hacker Lounge meet, greet, code, slack English en 20130523T190000 20130524T000000 05H00M00S Hacker Lounge- meet, greet, code, slack A place to gather... PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/618.en.html L140 Dan Langille PUBLISH 622@PGCon2013@pentabarf.org 622 hacker2 Hacker Lounge meet, greet, code, slack English en 20130522T190000 20130523T000000 05H00M00S Hacker Lounge- meet, greet, code, slack A place to gather... PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/622.en.html L140 Dan Langille PUBLISH 545@PGCon2013@pentabarf.org 545 Hacking on PostgreSQL Add your feature to PG! English en 20130523T133000 20130523T143000 01H00M00S Hacking on PostgreSQL- Add your feature to PG! We'll cover how to write your first patch to PG, submit it for review, and profit! PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/545.en.html MRT 221 Stephen Frost PUBLISH 566@PGCon2013@pentabarf.org 566 How Postgres Got Its Groove Back How a 25 Year Old Database Became The Next Big Thing English en 20130524T113000 20130524T123000 01H00M00S How Postgres Got Its Groove Back- How a 25 Year Old Database Became The Next Big Thing For a long time, Postgres has been the best kept secret of smart DBAs. Lately, it's become well-known that "all the cool kids" are using Postgres. In a recent Ruby on Rails community survey, more developers preferred Postgres in production to MySQL; Django's founder, Jacob Kaplan-Moss, has said given the option he'd only support Postgres. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/566.en.html MNT 202 Peter van Hardenberg PUBLISH 533@PGCon2013@pentabarf.org 533 Implementing High Availability Availability, Durability, Architecture, Replication... explained English en 20130524T100000 20130524T110000 01H00M00S Implementing High Availability- Availability, Durability, Architecture, Replication... explained How to implement PostgreSQL in a demanding project, what are the different technical offerings good for? All you wanted to know about replication and never dared to ask. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/533.en.html MNT 202 Dimitri Fontaine PUBLISH 556@PGCon2013@pentabarf.org 556 Introducing PostgreSQL Enterprise Consortium activities English en 20130524T163000 20130524T173000 01H00M00S Introducing PostgreSQL Enterprise Consortium activities PostgreSQL Enterprise Consortium (PGEcons) is a non-profit organization aiming for promoting PostgreSQL in production use, especially in mission critical area. It is formed by leading IT companies in Japan last year. Currently PGECons has 36 company members. In the first fiscal year, PGECons performed two major technical activities: PostgreSQL scale up/scale out evaluation (by Working Group 1: WG1) and establishing migration process from commercial DBMSs to PostgreSQL (by Working Group 2: WG2). These objectives were determined based on requests from PostgreSQL users and PGECons members and PGECons believes that sharing the experience is a big benefit for PostgreSQL community. In this talk we present current achievements of WG1 and WG2. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/556.en.html MNT 202 Hitoshi Hemmi Tatsuo Ishii PUBLISH 620@PGCon2013@pentabarf.org 620 lightning Lightning talks Short sharp descriptions of short topics English en 20130523T161500 20130523T171500 01H00M00S Lightning talks- Short sharp descriptions of short topics A regular feature, PGCon will have a Lightning talks session, with presentations on diverse topics. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/620.en.html MNT 202 Magnus Hagander PUBLISH 621@PGCon2013@pentabarf.org 621 socialouting Major Social Event! sponsored by EnterpriseDB English en 20130523T180000 20130523T210000 03H00M00S Major Social Event!- sponsored by EnterpriseDB EnterpriseDB invites all PGCon attendees to a big evening with drinks, appetizers, dinner and music on Thursday May 23rd at [My Condo](http://mycondoottawa.ca/), just minutes from the conference venue in the Byward Market. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/621.en.html Out and about Dan Langille PUBLISH 548@PGCon2013@pentabarf.org 548 Monitoring of Machines using PostgreSQL English en 20130523T100000 20130523T110000 01H00M00S Monitoring of Machines using PostgreSQL We have developed a versatile system to monitor machines and groups of machines. The system is well proven and used in industrial production, power supply industry, research and development. PostgreSQL is used to store all the measurements and metadata. The system also containes some SCADA elements. This talk explains the database related essentials of the monitoring part of the software. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/548.en.html MRT 256 Roland Sonnenschein PUBLISH 608@PGCon2013@pentabarf.org 608 Nulls Make Things Easier? English en 20130523T113000 20130523T123000 01H00M00S Nulls Make Things Easier? Nulls are a very useful but also very error-prone relational database feature. This talk is designed to help applications developers better manage their use of Nulls. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/608.en.html MRT 256 Bruce Momjian PUBLISH 577@PGCon2013@pentabarf.org 577 On the road to in-core logical replication!? Part 1: Architecture of Changeset Extraction English en 20130523T113000 20130523T123000 01H00M00S On the road to in-core logical replication!? Part 1: Architecture of Changeset Extraction Logical Replication in the context of postgres to this date consists out of several independent out-of-core solutions. While some of these solutions are great, the existance of many of those also causes problems like code duplication, lack of trust, features, reliability and peformance. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/577.en.html MRT 221 Andres Freund PUBLISH 518@PGCon2013@pentabarf.org 518 One step forward true json data type. Nested hstore with arrays support. English en 20130524T163000 20130524T173000 01H00M00S One step forward true json data type.- Nested hstore with arrays support. We present a prototype of nested hstore data type with arrays support. We consider the new hstore as a step forward true json data type. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/518.en.html MRT 221 Oleg Bartunov Teodor Sigaev PUBLISH 604@PGCon2013@pentabarf.org 604 PostgreSQL Backup Strategies English en 20130524T133000 20130524T143000 01H00M00S PostgreSQL Backup Strategies Rumor has it all these other users and companies do this thing called "backup" on their database. And people keep saying it's a good idea. But what does it actually mean? PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/604.en.html MRT 256 Magnus Hagander PUBLISH 633@PGCon2013@pentabarf.org 633 PostgreSQL Data Types Data types like you never saw them before A Whirlwind Tour of PostgreSQL Data Types English en 20130521T130000 20130521T160000 03H00M00S PostgreSQL Data Types- Data types like you never saw them before A Whirlwind Tour of PostgreSQL Data Types What's the great thing about a database? Why, it stores data of course! However, one feature that makes a database useful is the different data types that can be stored in it, and the breadth and sophistication of the data types in PostgreSQL is second-to-none, including some novel data types that do not exist in any other type of database software! This tutorial will take an in-depth look at all of the native data types built right into PostgreSQL as of version 9.2 (with some peeking ahead to 9.3). We will take a look at the functionality provided with each data type, examples of how they are used both in theory and practice, and of course, best practices that demonstrate the robustness of PostgreSQL. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/633.en.html MRT 256 Jim Mlodgenski Jonathan S. Katz PUBLISH 546@PGCon2013@pentabarf.org 546 PostgreSQL High Availability with Corosync/Pacemaker English en 20130524T113000 20130524T123000 01H00M00S PostgreSQL High Availability with Corosync/Pacemaker The Corosync/Pacemaker framework which is part of the LinuxHA stack can be used to provide monitoring and automatic failover capabilities. Now with streaming replication in place, it makes sense to use this robust infrastructure for PostgreSQL master and its replica handling. The open source pgsql resource agent also does this now. This talk will talk about using Corosync/Pacemaker with Postgres. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/546.en.html MRT 221 Nikhil Sontakke PUBLISH 602@PGCon2013@pentabarf.org 602 PostgreSQL on Hadoop Bridging the Divide with Distributed Foreign Tables English en 20130523T150000 20130523T160000 01H00M00S PostgreSQL on Hadoop- Bridging the Divide with Distributed Foreign Tables Apache Hadoop is an open-source framework that enables the construction of distributed, data-intensive applications running on clusters of commodity hardware. Building on a foundation initially composed of the MapReduce programming model and Hadoop Distributed Filesystem, in recent years Hadoop has expanded to include applications for data warehousing (Apache Hive), ETL (Apache Pig), and NoSQL column stores (Apache HBase). In this talk we describe recent work done at Citus Data that makes it possible to run a distributed version of PostgreSQL on top of Hadoop in a manner that combines the rich feature set and low-latency responsiveness of PostgreSQL with the scalability and performance characteristics of Hadoop. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/602.en.html MRT 256 Carl Steinbach PUBLISH 612@PGCon2013@pentabarf.org 612 PostgreSQL on ZFS Replication, Backup, and Human Disaster Recovery English en 20130522T090000 20130522T120000 03H00M00S PostgreSQL on ZFS- Replication, Backup, and Human Disaster Recovery The ZFS filesystem can be used simplify a number of replication, backup and recovery challenges. In this hands-on workshop, an introduction to the ZFS file system's features and capabilities will be presented, then a walk through of common scenarios where ZFS can save considerable hassle and countless hours when users and/or developers go astray. A VM will be provided for a hands-on experience. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/612.en.html MRT 256 Keith Paskett PUBLISH 516@PGCon2013@pentabarf.org 516 Postgres Preview A First Look At What's Coming In Postgres 9.3 English en 20130523T100000 20130523T110000 01H00M00S Postgres Preview- A First Look At What's Coming In Postgres 9.3 Postgres 9.3 is still a few months out, but we've already got some interesting things to play with. Join us in this overview of new features coming in Postgres 9.3, and see what goodies it has in store for you. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/516.en.html MRT 221 Robert Treat PUBLISH 619@PGCon2013@pentabarf.org 619 keynote Postgres at Disqus - keynote The present & the future English en 20130523T090000 20130523T094500 00H45M00S Postgres at Disqus - keynote- The present & the future Postgres at Disqus PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/619.en.html MNT 202 Mike Clarke PUBLISH 594@PGCon2013@pentabarf.org 594 PostgresSQL Concurrency How to manage race conditions in database access English en 20130523T100000 20130523T110000 01H00M00S PostgresSQL Concurrency- How to manage race conditions in database access This talk will discuss the problems which can occur when multiple database transactions are accessing the same data in PostgreSQL, and the various approaches to managing those problems. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/594.en.html MNT 202 Kevin Grittner PUBLISH 567@PGCon2013@pentabarf.org 567 Postgresql in Education Lessons learned from deploying Postgresql at University of Alberta English en 20130524T100000 20130524T110000 01H00M00S Postgresql in Education- Lessons learned from deploying Postgresql at University of Alberta University of Alberta migrated their central Learning Management System from Blackboard Vista on Oracle to Moodle on Postgresql 9.0 running inside VMWare cluster. We went from a pilot project of 13 courses in January 2011 to running all centrally supported courses (3600+) in Moodle in September 2012. Our central Moodle instance has seen more than 500,000 page loads and over 24,000 unique visitors in a single day. Since then we deployed Postgresql in a number of mission critical applications including our ticketing system and Enterprise Document Management system. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/567.en.html MRT 256 Greg Dostatni PUBLISH 557@PGCon2013@pentabarf.org 557 Query Planning Gone Wrong An analysis of common query planner failure modes English en 20130523T150000 20130523T160000 01H00M00S Query Planning Gone Wrong- An analysis of common query planner failure modes The PostgreSQL query planner does an excellent job with most queries, but no query planner is perfect. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/557.en.html MNT 202 Robert Haas PUBLISH 617@PGCon2013@pentabarf.org 617 registration Registration pickup The social way to register: at the pub English en 20130522T150000 20130522T190000 04H00M00S Registration pickup- The social way to register: at the pub Pick up your registration pack PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/617.en.html Royal Oak Dan Langille PUBLISH 571@PGCon2013@pentabarf.org 571 Row Level Security English en 20130523T150000 20130523T160000 01H00M00S Row Level Security Row-level security has a feature with longstanding development. It can enforce users to reference or modify part of rows according to the configured security policy. So, we can utilize this feature as if virtual private database on other commercial database, however, we designed this feature much carefully to keep both of reliable security and minimum performance trade-off. In addition, we enhanced usability to allow row-level security policy using usual expressions, also plan to integration with label based mandatory access control. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/571.en.html MRT 221 KaiGai Kohei PUBLISH 561@PGCon2013@pentabarf.org 561 SQL hints, tips, tricks and tuning English en 20130524T150000 20130524T160000 01H00M00S SQL hints, tips, tricks and tuning Performance tips and tricks on SQL level. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/561.en.html MNT 202 Susanne Ebrecht PUBLISH 611@PGCon2013@pentabarf.org 611 Sphinx and Postgres Full Text Search extension English en 20130523T133000 20130523T143000 01H00M00S Sphinx and Postgres- Full Text Search extension How to integrate both tools and obtain the best performance + reliability. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/611.en.html MRT 256 Emanuel Calvo PUBLISH 595@PGCon2013@pentabarf.org 595 The Billion Tables Project Aka how long a "\dt" takes on a 1B tables database English en 20130524T150000 20130524T160000 01H00M00S The Billion Tables Project- Aka how long a "\dt" takes on a 1B tables database Usually “large” databases are considered as such for the high number of records they hold, reaching billions or even more than that. But what about creating a billion... tables? Sometime ago, this apparently crazy question was found in a database soup (http://it.toolbox.com/blogs/database-soup/one-billion-tables-or-bust-46270). It may not be your day-to-day task, but the task of creating them exposes some topics about PostgreSQL internals, performance and large databases that may be really worth for your day-to-day. Join us for this talk, where we'll be discussing topics such as catalogue structure and storage requirements, table speed creation, differences between PostgreSQL versions and durability vs. table creation speed tradeoffs, among others. And, of course, how long a “\dt” takes on a 1B tables database :) PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/595.en.html MRT 256 Álvaro Hernández Tortosa PUBLISH 527@PGCon2013@pentabarf.org 527 The PGCon Schemaverse Tournament A DEFCON 21 Qualifier English en 20130523T123000 20130523T133000 01H00M00S The PGCon Schemaverse Tournament - A DEFCON 21 Qualifier The Schemaverse is a space-based strategy game implemented entirely within a PostgreSQL database. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/527.en.html MNT 202 Josh McDougall PUBLISH 632@PGCon2013@pentabarf.org 632 tourist Tourist Time See the sights in and/or around Ottawa English en 20130526T090000 20130526T140000 05H00M00S Tourist Time- See the sights in and/or around Ottawa Play Tourist PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/632.en.html Out and about Dan Langille PUBLISH 637@PGCon2013@pentabarf.org 637 Unconference Room #1 English en 20130525T100000 20130525T110000 01H00M00S Unconference- Room #1 This is where we will decide the content of the rest of the day. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/637.en.html MNT 202 Josh Berkus PUBLISH 626@PGCon2013@pentabarf.org 626 Unconference Room #1 English en 20130525T110000 20130525T130000 02H00M00S Unconference- Room #1 Turn up here to organize the rest of the day. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/626.en.html MNT 202 Josh Berkus PUBLISH 629@PGCon2013@pentabarf.org 629 Unconference Room #1 afternoon English en 20130525T140000 20130525T173000 03H30M00S Unconference- Room #1 afternoon The content of the day will be decided on the day. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/629.en.html MNT 202 Josh Berkus PUBLISH 628@PGCon2013@pentabarf.org 628 Unconference Room #2 English en 20130525T110000 20130525T130000 02H00M00S Unconference- Room #2 The content of the day will be decided on the day. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/628.en.html MRT 256 Josh Berkus PUBLISH 630@PGCon2013@pentabarf.org 630 Unconference Room #2 English en 20130525T140000 20130525T173000 03H30M00S Unconference- Room #2 The content of the day will be decided on the day. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/630.en.html MRT 221 Josh Berkus PUBLISH 631@PGCon2013@pentabarf.org 631 Unconference Room #2 English en 20130525T140000 20130525T173000 03H30M00S Unconference- Room #2 The content of the day will be decided on the day. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/631.en.html MRT 256 Josh Berkus PUBLISH 627@PGCon2013@pentabarf.org 627 Unconference Room #2 English en 20130525T110000 20130525T130000 02H00M00S Unconference- Room #2 The content of the day will be decided on the day. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/627.en.html MRT 221 Josh Berkus PUBLISH 564@PGCon2013@pentabarf.org 564 Understanding PostgreSQL timelines English en 20130524T133000 20130524T143000 01H00M00S Understanding PostgreSQL timelines Whenever you perform point-in-time-recovery or failover in PostgreSQL, a new timeline is created. In the best case, timelines help you stay sane in complicated recovery situations and keep your database consistent. In the worst case, they will thoroughly confuse you. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/564.en.html MNT 202 Heikki Linnakangas PUBLISH 591@PGCon2013@pentabarf.org 591 Use logging hooks for real-time log analysis If you want to know right now what your server has been doing English en 20130523T133000 20130523T143000 01H00M00S Use logging hooks for real-time log analysis- If you want to know right now what your server has been doing When problems arise, every DBA wants to know what the database has been up to. If your best idea so far has been to parse the log files or load the CSV logs into another database, you might want to learn about a better way. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/591.en.html MNT 202 Peter Eisentraut PUBLISH 574@PGCon2013@pentabarf.org 574 Using PostgreSQL with Redis Using native wrappers and a Foreign Data Wrapper for two-way Redis integration English en 20130524T100000 20130524T110000 01H00M00S Using PostgreSQL with Redis - Using native wrappers and a Foreign Data Wrapper for two-way Redis integration Redis is a high performance in-memory distributed data store, which can work well in conjunction with PostgreSQL in certain types of applications. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/574.en.html MRT 221 Andrew Dunstan PUBLISH 588@PGCon2013@pentabarf.org 588 Visualizing Postgres in realtime English en 20130524T133000 20130524T143000 01H00M00S Visualizing Postgres- in realtime Postgres comes with several introspection tools out of the box. Some are easier to understand than others, but they are all useful. Recent improvements in 9.2's pg_stat_statements make it even easier gain insights into the performance of your application. This talk will explore these built in tools, and what it takes to combine them to provide real-time visualizations of your database. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2013/schedule/events/588.en.html MRT 221 Will Leinweber