2.0 -//Pentabarf//Schedule #<Conference_release::Row:0x809144ef0>//EN PGCon2012 Schedule Release #<Conference_release::Row:0x809144ef0> PGCon2012 Schedule PUBLISH 441@PGCon2012@pentabarf.org 441 "Cheap, Fast AND Good" .... CHECK A checklist for database replication shoppers. English en 20120517T110000 20120517T120000 01H00M00S

"Cheap, Fast AND Good" .... CHECK- A checklist for database replication shoppers.

PostgreSQL's built in replication is available for a while now, yet all the previous solutions enjoy ongoing popularity. For the experts, this is hardly surprising. A) because none of the solutions was ever meant to replace anything else. B) because replication is one single term for several different attempts of solving a subset of many different problems. For IT decision makers this can be rather confusing. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/441.en.html MRT 218 Jan Wieck PUBLISH 423@PGCon2012@pentabarf.org 423 9.2: Full Throttle Database New Feature Grand Prix English en 20120517T093000 20120517T103000 01H00M00S

9.2: Full Throttle Database- New Feature Grand Prix

Gentlemen, start your database engines! PostgreSQL 9.2 beta is here, and it's faster and more exciting than ever before. Come down to the track and join us for a high-speed tour of the next version like never before! PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/423.en.html MRT 218 Josh Berkus PUBLISH 453@PGCon2012@pentabarf.org 453 A Batch of Commit Batching English en 20120518T100000 20120518T110000 01H00M00S

A Batch of Commit Batching

A database commit can be the most expensive single operation that its users have to wait for. Recent trends in the database industry have proven some applications are willing to accept durability loss, when it must be sacrificed to reach performance goals. And an inevitable downside of more durable approaches like Synchronous Replication are their impact on server commit speed. Some of the fundamental limitations here are physical ones: disk rotation, network performance, and the speed of light. Recent performance improvements changes for PostgreSQL 9.2 aim at getting closer to the theoretical best possible behavior here in every situation. It's more important than ever to tell when the limit you're hitting is a physical one, and when it's something you can address with a software change. Controlling commit batch size and the number of concurrent clients is getting even more important as PostgreSQL is deployed onto cloud and other virtual hardware environments. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/453.en.html MRT 218 Greg Smith Peter Geoghegan PUBLISH 488@PGCon2012@pentabarf.org 488 Big Bad "Upgraded" PostgreSQL English en 20120518T163000 20120518T173000 01H00M00S

Big Bad "Upgraded" PostgreSQL

A few years ago, we started a project to upgrade our multi-terabyte database from 8.3 to 8.4. Along the way we encountered a number of different obstacles and roadblocks which caused us to postpone the project, but this past fall we finally made it through phase 1 of the project, which by now had become an upgrade from 8.3 to 9.1. The course of the talk will cover several tools and tactics we had to use to get pg_upgrade to complete successfully, including all the different ways that things blew up on us. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/488.en.html MRT 218 Robert Treat PUBLISH 496@PGCon2012@pentabarf.org 496 Closing sessions prizes, auctions, fun, games English en 20120518T173000 20120518T183000 01H00M00S

Closing sessions- prizes, auctions, fun, games

The Traditional Closing Session PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/496.en.html MRT 218 Dan Langille PUBLISH 434@PGCon2012@pentabarf.org 434 Database Ops Easy and Effective Operation for production systems with PostgreSQL English en 20120517T130000 20120517T140000 01H00M00S

Database Ops- Easy and Effective Operation for production systems with PostgreSQL

NTT (Nippon Telegraph and Telephone) group has made effort to introduce PostgreSQL to its production systems that are large and mission-critical. Introducing PostgreSQL, we found it may be an obstacle that operation tools for PostgreSQL are not provided enough. So we have developed tools for backup, data load, and performance monitoring. In the talk, we will introduce these tools and how to improve database operation using them. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/434.en.html MRT 212 Tetsuo Sakata PUBLISH 462@PGCon2012@pentabarf.org 462 Dear SQL Server, I'm filing for divorce. Falling in love with the free spirit of Postgres English en 20120518T100000 20120518T110000 01H00M00S

Dear SQL Server, I'm filing for divorce.- Falling in love with the free spirit of Postgres

Using the StackOverFlow datasets, we'll ditch all the drama of a Microsoft stack and convert from SQL Server to Postgres on Windows. Once we do that, we'll migrate our entire DB and Web App from Microsoft to Linux using Postgres and Mono with as few code changes as possible. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/462.en.html MRT 205 Rob Sullivan PUBLISH 443@PGCon2012@pentabarf.org 443 Finding Similar Effective similarity search in database English en 20120517T130000 20120517T140000 01H00M00S

Finding Similar- Effective similarity search in database

Finding similar objects is an ubiquitous task in day-to-day activity of developers of informational services. We present PostgreSQL extension, which provides an effective way to find similar objects in database, as well as several usage examples. The extension provides several methods to calculate sets similarity and similarity operator with indexing support on the base of GiST and GIN frameworks. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/443.en.html MRT 219 Oleg Bartunov Teodor Sigaev PUBLISH 493@PGCon2012@pentabarf.org 493 Getting Hot and Streamy with Postgres Using Postgres' built in replication facilities English en 20120516T090000 20120516T120000 03H00M00S

Getting Hot and Streamy with Postgres- Using Postgres' built in replication facilities

An overview of Postgres' built in replication system, starting from PITR and going to cascading replication with demonstration's along the way. There will be more emphasis on the more recent and interesting technologies such as streaming replication and hot standby. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/493.en.html MRT 212 Phillip Sorber PUBLISH 506@PGCon2012@pentabarf.org 506 hacker1 Hacker Lounge meet, greet, code, slack English en 20120516T180000 20120516T230000 05H00M00S

Hacker Lounge- meet, greet, code, slack

A place to gather... PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/506.en.html L152 Dan Langille PUBLISH 507@PGCon2012@pentabarf.org 507 hacker3 Hacker Lounge meet, greet, code, slack English en 20120518T210000 20120519T000000 03H00M00S

Hacker Lounge- meet, greet, code, slack

A place to gather... PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/507.en.html L152 Dan Langille PUBLISH 508@PGCon2012@pentabarf.org 508 hacker2 Hacker Lounge meet, greet, code, slack English en 20120517T210000 20120518T000000 03H00M00S

Hacker Lounge- meet, greet, code, slack

A place to gather... PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/508.en.html L152 Dan Langille PUBLISH 466@PGCon2012@pentabarf.org 466 Hooks in PostgreSQL English en 20120518T113000 20120518T123000 01H00M00S

Hooks in PostgreSQL

PostgreSQL's extensibility is well known. Most people have heard of user types, user operators, the new extension capability, and such. But few know about hooks in PostgreSQL. This talk will cover all kinds of hooks available in PostgreSQL, and will show some tools using them already. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/466.en.html MRT 212 Guillaume Lelarge PUBLISH 483@PGCon2012@pentabarf.org 483 Improving foreign key concurrency To lock and not to block English en 20120518T133000 20120518T143000 01H00M00S

Improving foreign key concurrency- To lock and not to block

Row locking is a mechanism that lets Postgres maintain strict consistency in certain database constraints, such as foreign keys. However, Postgres has historically only provided share and exclusive row locking, which I'll show to have significant drawbacks for concurrency. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/483.en.html MRT 212 Álvaro Herrera PUBLISH 383@PGCon2012@pentabarf.org 383 Index support for regular expression search English en 20120518T150000 20120518T160000 01H00M00S

Index support for regular expression search

Regular expressions (regex) are powerful tool for text processing. When dealing with large string collections it's important to search fast on that collections (i.e. search using index). Indexing for regex search is a quite hard task. This talk presents novel technique (and WIP patch for PostgreSQL implementing it) for regex search using trigram indexes. Proposed technique provides more comprehensive trigram extraction than analogues, i.e. higher performance. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/383.en.html MRT 212 Alexander Korotkov PUBLISH 497@PGCon2012@pentabarf.org 497 keynote Keynote English en 20120517T090000 20120517T093000 00H30M00S

Keynote

One thing is certain: databases in the future are not going to look much like today. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/497.en.html MRT 218 Peter van Hardenberg PUBLISH 431@PGCon2012@pentabarf.org 431 Large Scale MySQL Migration to PostgreSQL! English en 20120517T130000 20120517T140000 01H00M00S

Large Scale MySQL Migration- to PostgreSQL!

Once a Top-10 internet audience site. 32 million users. Billions of photos and comments, more than 6TB of them. Migrating away from MySQL to PostgreSQL! This talk will share hindsights about the why and the how of that migration, what problems couldn't be solved without moving away and how the solution now looks. The tools used for migrating away the data, the methods and will detail the new architecture. And the new home, in the cloud! PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/431.en.html MRT 218 Dimitri Fontaine PUBLISH 489@PGCon2012@pentabarf.org 489 lightning Lightning talks Short sharp descriptions of short topics English en 20120517T160000 20120517T170000 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/2012/schedule/events/489.en.html MRT 218 Galy Lee Josh Berkus Magnus Hagander PUBLISH 404@PGCon2012@pentabarf.org 404 MADlib An open source machine learning library on RDBMS for Big Data age English en 20120517T110000 20120517T120000 01H00M00S

MADlib- An open source machine learning library on RDBMS for Big Data age

MADlib is an open-source library for scalable in-database analytics. It provides data-parallel implementations of mathematical, statistical and machine learning methods for structured and unstructured data. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/404.en.html MRT 212 Hitoshi Harada PUBLISH 504@PGCon2012@pentabarf.org 504 socialouting Major Social Event! sponsored by EnterpriseDB English en 20120517T180000 20120517T210000 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 17th at [My Condo](http://mycondoottawa.ca/), just minutes from the conference venue in the Byward Market. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/504.en.html Out and about Dan Langille PUBLISH 502@PGCon2012@pentabarf.org 502 socialouting2 Major Social Event! sponsored by Heroku English en 20120518T190000 20120518T210000 02H00M00S

Major Social Event!- sponsored by Heroku

Come and join us for an evening of food and drink at Patty Boland's in the Market. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/502.en.html Patty Boland's (upstairs) Dan Langille PUBLISH 432@PGCon2012@pentabarf.org 432 Making your own maps An introduction in using free Geospatial data English en 20120518T090000 20120518T100000 01H00M00S

Making your own maps- An introduction in using free Geospatial data

PostGIS is an extension to PostgreSQL that turns PostgreSQL into a superb spatial database. Storing spatial data in PostgreSQL is a great way too use up the space on your SSD's however using the data to make maps is much more fun. This talk is aimed at people with limited GIS experience and will talk about how to use OpenStreetMap data for map making. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/432.en.html MRT 212 Steve Singer PUBLISH 495@PGCon2012@pentabarf.org 495 Mastering PostgreSQL Administration afternoon session English en 20120515T130000 20120515T160000 03H00M00S

Mastering PostgreSQL Administration- afternoon session

In this two part course you will learn the essential details of PostgreSQL configuration, security, maintenance, monitoring, tuning, backups, recovery. The course is designed for people with experience in database administration but who are new to the Postgres platform. There will be a 1hr lunch break at noon. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/495.en.html MRT 212 Bruce Momjian Robert Treat PUBLISH 470@PGCon2012@pentabarf.org 470 Mastering PostgreSQL Administration 20120515T090000 20120515T120000 03H00M00S

Mastering PostgreSQL Administration

In this two part course you will learn the essential details of PostgreSQL configuration, security, maintenance, monitoring, tuning, backups, recovery. The course is designed for people with experience in database administration but who are new to the Postgres platform. There will be a 1hr lunch break at noon. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/470.en.html MRT 212 Bruce Momjian Robert Treat PUBLISH 426@PGCon2012@pentabarf.org 426 Monitoring Ozone Levels with Postgresql Database Streaming Replication and Monitoring English en 20120518T113000 20120518T123000 01H00M00S

Monitoring Ozone Levels with Postgresql- Database Streaming Replication and Monitoring

Postgres is used to manage data from the Ozone Monitoring Instrument aboard NASA's Aura spacecraft. The database implementation must handle large volumes of complex data transmitted continually from the satellite and generated by processing-intensive analyses performed by a team of atmospheric scientists. This talk will describe the architecture and some of the challenges faced. Focus will be given to our replication efforts, software developed for monitoring, and ongoing work to create a decentralized network of services commnicating through a RESTful interface. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/426.en.html MRT 205 Alex Ming Lai Marty Brandon PUBLISH 492@PGCon2012@pentabarf.org 492 Moving Day: Migrating Big Data from A to B English en 20120518T113000 20120518T123000 01H00M00S

Moving Day: Migrating Big Data from A to B

In 2011 we moved the Mozilla crash reporting system from old creaky hardware in San Jose to a new shiny datacenter in Phoenix. This system contains more than 40TB of data in HBase, the Hadoop database, and PostgreSQL. The data collecting app has a requirement for close to 100% uptime. On top of that we have data processing, an API, and a webapp. After many months of work, the migration went seamlessly. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/492.en.html MRT 218 Laura Thomson PUBLISH 387@PGCon2012@pentabarf.org 387 OLTP Performance Benchmarks Overview English en 20120518T133000 20120518T143000 01H00M00S

OLTP Performance Benchmarks Overview

Learn about various OLTP Performance benchmark kits , when to use them and what to know when comparing numbers with other databases. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/387.en.html MRT 205 Jignesh K. Shah PUBLISH 417@PGCon2012@pentabarf.org 417 On snakes and elephants Using Python with and in PostgreSQL English en 20120518T100000 20120518T110000 01H00M00S

On snakes and elephants- Using Python with and in PostgreSQL

Python is one of the most popular application programming languages and there's a plethora of PostgreSQL libraries and utilities for Python. This talk will try to give an overview of the contemporary Python-PostgreSQL landscape in a way that's useful both for Python programmers starting on a PostgreSQL project and DBAs dealing with what those programmers wrote. We'll try cover a slightly opinionated selection of libraries, frameworks and technologies and give some recommendations. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/417.en.html MRT 212 Jan Urbański PUBLISH 437@PGCon2012@pentabarf.org 437 PL/R Tricks Server Monitoring with Predictive Analytics English en 20120517T143000 20120517T153000 01H00M00S

PL/R Tricks- Server Monitoring with Predictive Analytics

We will present the results of an investigation into the use of PostgreSQL and PL/R in conjunction with a server monitoring application to perform predictive analytics of server performance. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/437.en.html MRT 219 Jeff Hamann Joe Conway PUBLISH 416@PGCon2012@pentabarf.org 416 Performance Improvements in PostgreSQL 9.2 Bigger servers, bigger problems English en 20120518T150000 20120518T160000 01H00M00S

Performance Improvements in PostgreSQL 9.2- Bigger servers, bigger problems

The upcoming PostgreSQL 9.2 release features a large number of performance enhancements by many different authors, including heavyweight lock manager improvements, reduced lock hold times in key hot spots, better group commit, index-only scans, better write-ahead log parallelism, sorting improvements, and a userspace AVC for sepgsql. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/416.en.html MRT 218 Robert Haas PUBLISH 419@PGCon2012@pentabarf.org 419 PostgreSQL on AWS EC2 with somewhat reduced tears English en 20120518T133000 20120518T143000 01H00M00S

PostgreSQL on AWS- EC2 with somewhat reduced tears

Amazon Web Services (AWS) has become a very popular platform for deploying PostgreSQL-backed applications. But it's not a standard hosting platform. We'll talk about how to get PostgreSQL to run efficiently and safely on AWS. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/419.en.html MRT 218 Christophe Pettus PUBLISH 439@PGCon2012@pentabarf.org 439 Range Types and Temporal: Past, Present, and Future English en 20120517T143000 20120517T153000 01H00M00S

Range Types and Temporal: Past, Present, and Future

Range Types didn't exist before, why do we need them now? How do they work? Why is "Temporal" important if we already have timestamps? How do we apply these concepts before deploying PostgreSQL 9.2? What's left to be done, and what solutions are in the works? PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/439.en.html MRT 212 Jeff Davis PUBLISH 498@PGCon2012@pentabarf.org 498 registration Registration pickup The social way to register: at the pub English en 20120516T150000 20120516T190000 04H00M00S

Registration pickup- The social way to register: at the pub

Pick up your registration pack PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/498.en.html Royal Oak Dan Langille PUBLISH 465@PGCon2012@pentabarf.org 465 Running libraries on PostgreSQL The Evergreen library system's (ab)use of PostgreSQL English en 20120518T150000 20120518T160000 01H00M00S

Running libraries on PostgreSQL- The Evergreen library system's (ab)use of PostgreSQL

Launched by the Georgia Public Library System in September 2006 to manage and circulate materials through a consortia of over 200 public libraries, Evergreen has since been adopted by over 1,000 public and academic libraries across more than 30 states and provinces. From the beginning, Evergreen's distributed architecture has bet heavily on PostgreSQL features, relying on custom functions, triggers and rules, full-text search, XML support, inheritance, and recently HSTORE to provide reliable high-performance support for the day-to-day operations of libraries. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/465.en.html MRT 205 Dan Scott PUBLISH 468@PGCon2012@pentabarf.org 468 Schemaless SQL The Best of Both Worlds English en 20120517T110000 20120517T120000 01H00M00S

Schemaless SQL- The Best of Both Worlds

Schemaless database are a joy to use because they make it easy to iterate on your app, especially early on. And to be honest, the relational model isn't always the best fit for real-world evolving and messy data. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/468.en.html MRT 219 Will Leinweber PUBLISH 509@PGCon2012@pentabarf.org 509 schema Schemaverse Learn more about the tournament format, available prizes, game mechanics or even simply discuss the idea English en 20120517T120000 20120517T130000 01H00M00S

Schemaverse- Learn more about the tournament format, available prizes, game mechanics or even simply discuss the idea

Compete against your fellow PostgreSQL users for prizes and the honor of the Schemaverse Champion title. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/509.en.html MRT 212 Josh 'Abstrct' McDougall PUBLISH 479@PGCon2012@pentabarf.org 479 Simple SQL Change Management with Sqitch English en 20120518T163000 20120518T173000 01H00M00S

Simple SQL Change Management with Sqitch

SQL change management has always sucked. This talk introduces Sqitch, the VCS-aware SQL change management application that doesn’t suck. Come see how it works, learn the few simple rules you need to get the most out of it, and liberate yourself from the suckitude. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/479.en.html MRT 205 David E. Wheeler PUBLISH 446@PGCon2012@pentabarf.org 446 The Horizontal Struggle Improving the Experience of Scale-Out English en 20120518T090000 20120518T100000 01H00M00S

The Horizontal Struggle- Improving the Experience of Scale-Out

Horizontal scale-out of applications using Postgres is typically a time-consuming, expensive, error-prone task. In spite of that, horizontal scale-out is achievable, even if not well-supported by the logical constructs Postgres exposes. This talk is intended to share what we've learned from both our experiences at Heroku and, more importantly, the litany of customers that we are privileged to talk to about their problems. From these, a few choice gaps in functionality are highlighted for improvement. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/446.en.html MRT 218 Daniel Farina PUBLISH 450@PGCon2012@pentabarf.org 450 The PostgreSQL replication protocol, tools and opportunities English en 20120518T163000 20120518T173000 01H00M00S

The PostgreSQL replication protocol, tools and opportunities

The new binary replication protocols and tools in PostgreSQL 9.0 and 9.1 are a popular new feature - but they can also be used for other things than just replication! PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/450.en.html MRT 212 Magnus Hagander PUBLISH 503@PGCon2012@pentabarf.org 503 tourist Tourist stuff Spend some time exploring English en 20120519T100000 20120519T150000 05H00M00S

Tourist stuff- Spend some time exploring

Explore Ottawa PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/503.en.html Out and about Dan Langille PUBLISH 424@PGCon2012@pentabarf.org 424 Tutorial - Configuring write-scalable PostgreSQL cluster Postgres-XC primer and more English en 20120516T130000 20120516T160000 03H00M00S

Tutorial - Configuring write-scalable PostgreSQL cluster- Postgres-XC primer and more

Postgres-XC (simply XC) is write-scalable PostgreSQL cluster, which will be generally available by early May, 2012. So far, XC is only one write-scalable, symetric database cluster solution available as open source. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/424.en.html MRT 212 Ashutosh Bapat Koichi Suzuki Michael Paquier PUBLISH 454@PGCon2012@pentabarf.org 454 Unlocking the Postgres Lock Manager English en 20120517T143000 20120517T153000 01H00M00S

Unlocking the Postgres Lock Manager

Locking is critical for providing high concurrency for any database — you cannot fully utilize your hardware if locking is throttling its use. This talk explores all aspects of locking in Postgres by showing queries and their locks; covered lock types include row, table, shared, exclusive, and advisory lock types. The high concurrency provided by Multiversion Concurrency Control (MVCC) is also covered. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/454.en.html MRT 218 Bruce Momjian PUBLISH 415@PGCon2012@pentabarf.org 415 Using PostgreSQL in modern enterprise web applications Using HTML5, JavaScript, NodeJS with PostgreSQL English en 20120517T093000 20120517T103000 01H00M00S

Using PostgreSQL in modern enterprise web applications- Using HTML5, JavaScript, NodeJS with PostgreSQL

PostgreSQL's object relational heritage makes it an outstanding choice for developing web applications that have a rich object model domain. See how PostgreSQL's object relational features allow for building database models to support a NodeJS data service feeding a 100% JavaScript web client. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/415.en.html MRT 212 John Rogelstad PUBLISH 408@PGCon2012@pentabarf.org 408 WAL Internals Of PostgreSQL English en 20120518T090000 20120518T100000 01H00M00S

WAL Internals Of PostgreSQL

Describes the Write-Ahead-Log Internals of PostgreSQL system. Improvements in WAL system that can be done to improve the performance. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/408.en.html MRT 205 Amit Kapila PUBLISH 440@PGCon2012@pentabarf.org 440 Writing a foreign data wrapper Experiences with Informix English en 20120517T093000 20120517T103000 01H00M00S

Writing a foreign data wrapper- Experiences with Informix

Writing a foreign data wrapper (FDW) for PostgreSQL seems easy. However, there are many pitfalls. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2012/schedule/events/440.en.html MRT 219 Bernd Helmle