2.0 -//Pentabarf//Schedule #<Conference_release::Row:0x80823b580>//EN PGCon2010 Schedule Release #<Conference_release::Row:0x80823b580> PGCon2010 Schedule PUBLISH 224@PGCon2010@pentabarf.org 224 2 years of londiste PostgreSQL usage at Hi-Media English en 20100521T133000 20100521T143000 01H00M00S 2 years of londiste- PostgreSQL usage at Hi-Media Hi-Media online services all run atop PostgreSQL, and use some form of replication. This talk will present what problems we solve with replication, and how. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/224.en.html DMS 1160 Dimitri Fontaine PUBLISH 259@PGCon2010@pentabarf.org 259 Application-level Authorization via SET ROLE Working around connection pooling for permissions English en 20100520T100000 20100520T110000 01H00M00S Application-level Authorization via SET ROLE - Working around connection pooling for permissions Discussing why integrating application authorization with your database is a good idea, downsides to such integration, implementation gotchas, and finally covering an example implementation. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/259.en.html DMS 1150 Aurynn Shaw PUBLISH 264@PGCon2010@pentabarf.org 264 Built-in replication in PostgreSQL 9.0 English en 20100520T100000 20100520T110000 01H00M00S Built-in replication in PostgreSQL 9.0 An introduction to the new built-in replication features in PostgreSQL 9.0, Hot Standby and Streaming Replication. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/264.en.html DMS 1140 Heikki Linnakangas PUBLISH 257@PGCon2010@pentabarf.org 257 Check Please! What Your Postgres Databases Wishes You Would Monitor English en 20100521T133000 20100521T143000 01H00M00S Check Please!- What Your Postgres Databases Wishes You Would Monitor Compared to many proprietary systems, Postgres tends to be pretty straight forward to run. However, if you want to get the most from your 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 review several key metrics you should be aware of, and explain under which scenarios you may need additional monitoring. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/257.en.html DMS 1150 Robert Treat PUBLISH 247@PGCon2010@pentabarf.org 247 Closing sessions prizes, auctions, fun, games English en 20100521T173000 20100521T180000 00H30M00S Closing sessions- prizes, auctions, fun, games The Traditional Closing Session PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/247.en.html DMS 1160 Dan Langille PUBLISH 270@PGCon2010@pentabarf.org 270 cluster Cluster-Hackers BOF cluster like you mean it English en 20100521T180000 20100521T200000 02H00M00S Cluster-Hackers BOF- cluster like you mean it Anyone interested in working on clustering solutions to PostgreSQL please attend this BOF. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/270.en.html DMS 1150 Josh Berkus PUBLISH 227@PGCon2010@pentabarf.org 227 Efficient k-nn search with GiST and other development English en 20100520T113000 20100520T123000 01H00M00S Efficient k-nn search with GiST and other development We present implementation of new GiST tree traverse strategy and efficient k-nn search based on this strategy. Also, we'd like to discuss new signature file based index (bloom index), it's implementation and possible improvements. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/227.en.html DMS 1140 Oleg Bartunov Teodor Sigaev PUBLISH 205@PGCon2010@pentabarf.org 205 Exposing PostgreSQL Internals with User-Defined Functions Easing into PostgreSQL Hacking English en 20100520T133000 20100520T143000 01H00M00S Exposing PostgreSQL Internals with User-Defined Functions- Easing into PostgreSQL Hacking User-defined functions are one of the easiest ways to get started hacking on the PostgreSQL codebase and produce something useful in a short 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 along the way. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/205.en.html DMS 1160 Greg Smith PUBLISH 234@PGCon2010@pentabarf.org 234 Forensic Analysis of Corrupted Databases What to do when things really hit the fan 20100520T150000 20100520T160000 01H00M00S Forensic Analysis of Corrupted Databases- What to do when things really hit the fan A look at some of the typical symptoms of corrupted databases, the usual culprits which cause problems, and a survey of strategies for correcting problems. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/234.en.html DMS 1150 Greg Stark PUBLISH 233@PGCon2010@pentabarf.org 233 Hypothetical Indexes towards self-tuning in PostgreSQL English en 20100520T113000 20100520T123000 01H00M00S Hypothetical Indexes towards self-tuning in PostgreSQL We propose to add hypothetical (or virtual) indexes in order to offer both what-if querying and automatic index tuning. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/233.en.html DMS 1160 Sergio Lifschitz PUBLISH 217@PGCon2010@pentabarf.org 217 LAPP/SELinux A secure web-application stack using SE-PostgreSQL English en 20100520T150000 20100520T160000 01H00M00S LAPP/SELinux- A secure web-application stack using SE-PostgreSQL Nowadays, many web applications are closely combined with database systems, using the database to provide various kinds of dynamic content. In these environments, you cannot just focus on individual applications, databases and the operating systems. You need to consider the whole system. This session describes why you should apply consistent and centralized access control policy, how SE-PostgreSQL can be utilized to improve web application security, and shows a working example of the stack named as LAPP/SELinux. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/217.en.html DMS 1140 KaiGai Kohei PUBLISH 267@PGCon2010@pentabarf.org 267 lightning Lightning talks Short sharp descriptions of short topics English en 20100520T173000 20100520T183000 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/2010/schedule/events/267.en.html DMS 1160 Magnus Hagander Selena Deckelmann PUBLISH 218@PGCon2010@pentabarf.org 218 Monitoring PostgreSQL Buffer Cache Internals Watching disk caching inside the database English en 20100521T113000 20100521T123000 01H00M00S Monitoring PostgreSQL Buffer Cache Internals- Watching disk caching inside the database When you give your database server memory, you expect it's going to use it. But for what? A look inside PostgreSQL's buffer cache can tell you exactly what that memory is doing for you. Every systematic database tuning effort should include a look at this critical resource. When it comes to optimization work, profiling beats guessing every time. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/218.en.html DMS 1160 Greg Smith PUBLISH 202@PGCon2010@pentabarf.org 202 No More Waiting A Guide To PostgreSQL 9.0 English en 20100518T090000 20100518T120000 03H00M00S No More Waiting- A Guide To PostgreSQL 9.0 Another year, another PostgreSQL release, and once again this release packed full of new features. This talk will give an overview of the 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 the one who has to keep them running, this should be your first stop on the road to 8.5. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/202.en.html DMS 1110 Robert Treat PUBLISH 201@PGCon2010@pentabarf.org 201 Not Just UNIQUE Exclusion Constraints English en 20100520T133000 20100520T143000 01H00M00S Not Just UNIQUE- Exclusion Constraints UNIQUE is no longer unique among constraints. I authored "Exclusion Constraints" for PostgreSQL 8.5: a more general constraint mechanism that can enforce constraints such as "non-overlapping" as well as unique; and can enforce constraints on GiST or hash indexes as well as BTree. See why other constraint mechanisms are unsuitable for common business requirements -- like handling schedule conflicts -- and how the problems are solved by using Exclusion Constraints. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/201.en.html DMS 1150 Jeff Davis PUBLISH 274@PGCon2010@pentabarf.org 274 enova Online financial services & Postgres Staking our claim on open source technologies English en 20100521T100000 20100521T110000 01H00M00S Online financial services & Postgres- Staking our claim on open source technologies Enova Financial provides online financial services to under-served consumers in the United States, Great Britain, Australia and Canada. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/274.en.html DMS 1140 Jim Nasby PUBLISH 273@PGCon2010@pentabarf.org 273 socialouting PGCon 2010 Major Social Event! sponsored by EnterpriseDB English en 20100520T190000 20100520T223000 03H30M00S PGCon 2010 Major Social Event!- sponsored by EnterpriseDB Come and join us for the major social event of PGCon 2010 PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/273.en.html The Velvet Room Dan Langille PUBLISH 200@PGCon2010@pentabarf.org 200 PL/Parrot Yep, there's actually code now! English en 20100521T100000 20100521T110000 01H00M00S PL/Parrot- Yep, there's actually code now! Calling functions written in one PL from another shouldn't be painful, and with PL/Parrot, it won't be. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/200.en.html DMS 1160 David Fetter Jonathan Leto PUBLISH 207@PGCon2010@pentabarf.org 207 PL/Perl - new features in 9.0 English en 20100521T163000 20100521T173000 01H00M00S PL/Perl - new features in 9.0 Find out all you need to know about the new PL/Perl features in PostgreSQL 9.0 PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/207.en.html DMS 1160 Tim Bunce PUBLISH 219@PGCon2010@pentabarf.org 219 Perspectives on NoSQL What NoSQL means to PostgreSQL and why PostgreSQL is YesQL. English en 20100520T090000 20100520T100000 01H00M00S Perspectives on NoSQL- What NoSQL means to PostgreSQL and why PostgreSQL is YesQL. The NoSQL movement has captured the attention of many web developers, often times using the myth that SQL databases like PostgreSQL do not scale as well as newer technologies. We wil examine many of the more popular key/value store databases and illustrate the pros and cons of using a "NoSQL" database, examining the features of the more popular NoSQL alternatives in comparison to PostgreSQL. More importantly, we will address the impact of NoSQL technology at scale as it compares to PostgreSQL and ultimately discover why PostgreSQL is the YesQL alternative to today's upstart database technologies. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/219.en.html DMS 1160 Gavin M. Roy PUBLISH 261@PGCon2010@pentabarf.org 261 PgFincore and the OS Page Cache Is my table in memory ? English en 20100520T150000 20100520T160000 01H00M00S PgFincore and the OS Page Cache- Is my table in memory ? While PostgreSQL can see the contents of shared buffers, it does not know about the OS page cache, which in turn tells which pages are actually in memory. PgFincore provides this information, which allows us to: - Preload the exact pages that PostgreSQL will probably want in order to respond more quickly to the first queries on server restart. - Try to improve planner choice and cost estimation. It suggest ideas to : - Keep pg_dump from trashing the OS Page Cache - Explicitly ask for a non-cached sequential scan. PgFincore also provides information about how the data in the OS page cache is distributed. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/261.en.html DMS 1160 Cedric Villemain PUBLISH 251@PGCon2010@pentabarf.org 251 PgMQ PgMQ: Embedding messaging in PostgreSQL English en 20100521T100000 20100521T110000 01H00M00S PgMQ- PgMQ: Embedding messaging in PostgreSQL Embedded Messaging with PgMQ, the PostgreSQL Message Queueing add-on PgMQ embeds messaging directly into PostgreSQL so that committed transactions can be published to message queues via various popular messaging protocols (AMQP, STOMP, OpenWire). Supports ActiveMQ (STOMP, OpenWire) and any transport supporting AMQP (such as RabbitMQ). PgMQ easily enables "eventually consistent" replication and/or sharding along customized data boundaries. PgMQ also introduces an index extension that enhances temporal data types (timestamp, date, etc.) by firing an event (trigger) when the value is equal to current_time, an aid to replication and partitioning. This lecture will show how to set up and configure PGMQ, with realtime examples. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/251.en.html DMS 1150 Chris Bohn PUBLISH 242@PGCon2010@pentabarf.org 242 PostgreSQL Access Controls (AuthN, AuthZ, Perms) Controlling Access to your database- Roles; Kerberos, LDAP, SSL, RADIUS(!); Database Permissions English en 20100519T130000 20100519T160000 03H00M00S PostgreSQL Access Controls (AuthN, AuthZ, Perms)- Controlling Access to your database- Roles; Kerberos, LDAP, SSL, RADIUS(!); Database Permissions An introduction and thorough review of access control in PostgreSQL. All access control will be covered, but special attention will be paid to new features and changes in 8.5. This will include both System Admin configuration specifics (hba.conf) and Database Admin permissions (GRANT system). PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/242.en.html DMS 1110 Stephen Frost PUBLISH 210@PGCon2010@pentabarf.org 210 PostgreSQL as a secret weapon for high-performance Ruby on Rails applications English en 20100521T113000 20100521T123000 01H00M00S PostgreSQL as a secret weapon for high-performance Ruby on Rails applications This session will cover lessons learned about Ruby on Rails development using PostgreSQL. From the database-centric view the session will explain Rails best practices, taking advantage of RoR strong points, dealing with its weak points, PostgreSQL strong and weak points, and using advanced SQL features in web applications. The session will demonstrate how PostgreSQL is used to speedup Rails code, making slow things in your web application fast and impossible things - possible. The session will also discuss the peculiarities of complex enterprise apps and show that PostgreSQL is an ideal open source match for their development. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/210.en.html DMS 1140 Gleb Arshinov Oleksandr Dymo PUBLISH 204@PGCon2010@pentabarf.org 204 PostgreSQL in Mission-Critical Financial Systems Case study of PostgreSQL in the Multicanal project of the brazilian bank Caixa Economica Federal English en 20100520T113000 20100520T123000 01H00M00S PostgreSQL in Mission-Critical Financial Systems- Case study of PostgreSQL in the Multicanal project of the brazilian bank Caixa Economica Federal Case study of PostgreSQL in the project "Multicanal" of the brazilian 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 public institution. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/204.en.html DMS 1150 Flavio Gurgel PUBLISH 238@PGCon2010@pentabarf.org 238 Postgres for non-Postgres people Getting to know the Postgres way English en 20100520T100000 20100520T110000 01H00M00S Postgres for non-Postgres people- Getting to know the Postgres way Experience in one database system does not always make learning another one easy. Although Postgres is more SQL-compliant than just about anything else, there are plenty of quirks, features, and gotchas that you should be aware of. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/238.en.html DMS 1160 Greg Sabino Mullane PUBLISH 226@PGCon2010@pentabarf.org 226 Postgres-XC, Write-scalable, synchronous multi-master PostgreSQL cluster with shared nothing approach English en 20100521T163000 20100521T173000 01H00M00S Postgres-XC, Write-scalable, synchronous multi-master PostgreSQL cluster with shared nothing approach We will present a new PostgreSQL cluster called Postgres-XC (Extensible Cluster) developed by NTT and EnterpriseDB. Postgres-XC's performance is write-scalable. It also provides synchronous multi-master capability. Updates through one master are visible from any other masters immediately after the commit. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/226.en.html DMS 1150 Koichi Suzuki Mason Sharp PUBLISH 220@PGCon2010@pentabarf.org 220 Probing PostgreSQL with DTrace and SystemTap English en 20100521T133000 20100521T143000 01H00M00S Probing PostgreSQL with DTrace and SystemTap Operating system developments in recent years have provided administrators with new and powerful ways of peeking into live, production applications to investigate behaviors and solve problems in real time without significant system impact. PostgreSQL provides several probe points allowing these dynamic tracing tools access to running applications that was formerly available only with a debugger. In this discussion we will explore the DTrace and SystemTap applications and some of their capabilities, with specific focus on PostgreSQL. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/220.en.html DMS 1140 Joshua Tolley PUBLISH 246@PGCon2010@pentabarf.org 246 pub Pub Night! Last chance for social intercourse before the Touristy stuff tomorrow English en 20100521T183000 20100521T233000 05H00M00S Pub Night!- Last chance for social intercourse before the Touristy stuff tomorrow The last big social event... PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/246.en.html Royal Oak Dan Langille PUBLISH 213@PGCon2010@pentabarf.org 213 Realistic Load Testing HOWTO set up a realistic testing environment using PostgreSQL Functions and Python English en 20100519T090000 20100519T120000 03H00M00S Realistic Load Testing- HOWTO set up a realistic testing environment using PostgreSQL Functions and Python Applications and databases need testing. But how can you get valid results for a fully integrated system Flight-Check test at realistic loads? This tutorial addresses the many challenges that arise in an application or database development to give confidence to you and your customers in presenting a production-ready product. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/213.en.html DMS 1110 Zach Conrad PUBLISH 244@PGCon2010@pentabarf.org 244 Reconciling and comparing databases redux Deploying and testing triggers and functions in multiple databases English en 20100521T150000 20100521T160000 01H00M00S Reconciling and comparing databases redux- Deploying and testing triggers and functions in multiple databases The Millburn Corporation is a hedge fund which uses complex data-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 database 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 compare 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 database environment: how to test complex triggers and functions before they're deployed; and how to reconcile and track changes in these functions as they move from our development to our staging and production environments. Specifically, I'll describe how we make use of subversion, pg_dump and pgTAP to roll trigger and function changes to our development environment nightly; and how we test the integrity of the functions and trigger functions on our staging and production environments nightly using pgTAP. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/244.en.html DMS 1160 Norman Yamada PUBLISH 266@PGCon2010@pentabarf.org 266 registration Registration pickup The social way to register: at the pub English en 20100519T150000 20100519T183000 03H30M00S Registration pickup- The social way to register: at the pub Pick up your registration pack PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/266.en.html Royal Oak Dan Langille PUBLISH 211@PGCon2010@pentabarf.org 211 Replacing GEQO Join ordering via Simulated Annealing English en 20100521T150000 20100521T160000 01H00M00S Replacing GEQO- Join ordering via Simulated Annealing Finding the optimal join order for an arbitrary number of relations is an NP-hard problem. For small queries applying exhaustive search is feasible, but the runtime and memory consumption make that approach impractical in many real-life applications. PostgreSQL's answer to that problem is GEQO: the genetic query optimizer. It employs heuristics similar to those commonly used for solving the Travelling Salesman Problem. However, recent studies suggest other randomized algorithms could yield better results in shorter time. One such approach, called Simulated Annealing, will be presented, along with a prototype implementation that you can load and try against your most monstrous queries. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/211.en.html DMS 1150 Jan Urbański PUBLISH 268@PGCon2010@pentabarf.org 268 Replication Panel English en 20100521T113000 20100521T123000 01H00M00S Replication Panel PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/268.en.html DMS 1150 PUBLISH 231@PGCon2010@pentabarf.org 231 Secure PostgreSQL Deployment English en 20100521T150000 20100521T160000 01H00M00S Secure PostgreSQL Deployment PostgreSQL supports several options for securing communications and access when deployed outside the typical webserver/database combination. This talk will discuss the features that make this possible, with some extra focus on the changes in 8.4 and 8.5. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/231.en.html DMS 1140 Magnus Hagander PUBLISH 223@PGCon2010@pentabarf.org 223 Server Health Check Give your Postgres server a checkup English en 20100518T130000 20100518T160000 03H00M00S Server Health Check- Give your Postgres server a checkup Have you given your PostgreSQL database server a checkup lately? If not, you probably should. "Sick" database servers are easy to prevent if you take a few simple steps <i>before</i> your server comes down with something. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/223.en.html DMS 1110 Josh Berkus PUBLISH 271@PGCon2010@pentabarf.org 271 bof1 Testing BOF Testing your database English en 20100521T180000 20100521T200000 02H00M00S Testing BOF- Testing your database Calling all database testers! PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/271.en.html DMS 1160 David E. Wheeler PUBLISH 228@PGCon2010@pentabarf.org 228 The Illustrated Elephant Literary modeling and automatic documentation in PostgreSQL English en 20100520T163000 20100520T173000 01H00M00S The Illustrated Elephant- Literary modeling and automatic documentation in PostgreSQL Users of proprietary database management systems are usually bound to use graphical modeling tools with an emphasis on drawing diagrams and generating SQL DDL code from them. The process is generally error-prone and cumbersome, being based on mediochre user interfaces and generating bad SQL representing poor data models, as diagrams can hardly represent the full richness of SQL data models — specially in an SQL flavor like PostgreSQL’s. Many databases are reverse-engineered into entity-relationship diagrams, loosing much information coded into SQL features not directly supported by the diagramming tools, or in the SQL DDL source code which originally created the reverse-engineered database. A well-kept but open secret of many database administrators is reliance on source code and automatic diagramming tools. Breaking free from the misconception that all information should be graphically represented, or even that it should be graphically created, and from the mistaken identification of modeling and drawing, such data modelers are free to use the full power of both SQL and their well-proven, flexible source code tools, all the while generating all the graphics and web pages they could possibly want automatically, using simple, fast programs which can lay out diagrams much better than most drafters. SQL DDL coding can also be nicely combined to literary programming tools, in what we call ‘literary modeling’: interspersing SQL DDL statements in a full text explanation of the model and the reasoning behind it, we can generate both text files for database schema creation, and nicely formatted documents for reading, browsing and reference, both printed and online. These documents can, and typically will, include graphics generated automatically from either the SQL DDL or the database schema itself. It is our tested conviction that this process is much more pleasurable and efficient than the tradicional diagram-based one. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/228.en.html DMS 1160 Leandro Guimarães Faria Corcete DUTRA PUBLISH 208@PGCon2010@pentabarf.org 208 The PostgreSQL Query Planner English en 20100520T163000 20100520T173000 01H00M00S The PostgreSQL Query Planner Why does my query need a plan? Sequential scan vs. index scan. Join strategies. Join reordering. Using EXPLAIN. Row count and cost estimation. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/208.en.html DMS 1150 Robert Haas PUBLISH 235@PGCon2010@pentabarf.org 235 To ORM or not to ORM (that's the question) Exploring both DBA's and programmers point-of-view English en 20100520T163000 20100520T173000 01H00M00S To ORM or not to ORM (that's the question)- Exploring both DBA's and programmers point-of-view 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 database community in a new strategy of collaboration where a new interface (say "API") between both is designed. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/235.en.html DMS 1140 Álvaro Hernández Tortosa PUBLISH 272@PGCon2010@pentabarf.org 272 tourist Tourist stuff Spend some time exploring English en 20100522T093000 20100522T143000 05H00M00S Tourist stuff- Spend some time exploring Explore Ottawa PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/272.en.html Out and about Dan Langille PUBLISH 258@PGCon2010@pentabarf.org 258 Using Git to work with PostgreSQL English en 20100521T163000 20100521T173000 01H00M00S Using Git to work with PostgreSQL The talk will explore using Git to work with PostgreSQL in various roles, including: tester, reviewer, developer, committer and buildfarm owner. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/258.en.html DMS 1140 Andrew Dunstan PUBLISH 269@PGCon2010@pentabarf.org 269 bof3 We have money, do you have the time? How commercial companies can fund Postgres development. English en 20100521T180000 20100521T200000 02H00M00S We have money, do you have the time?- How commercial companies can fund Postgres development. Postgres has grown to the point where it is very difficult to add missing features without financial support from commercial users and cooperation between companies providing Postgres support as well as general community members. PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/269.en.html DMS 1140 Jim Nasby PUBLISH 216@PGCon2010@pentabarf.org 216 pg_statsinfo More useful statistics information for DBAs English en 20100520T133000 20100520T143000 01H00M00S pg_statsinfo- More useful statistics information for DBAs NTT has developed "pg_statsinfo", that collects database activities and statistics automatically, and shows the information to DBAs in user-friendly shapes. Also pg_statsinfo can collect statistics from multiple DBs, so this tool makes it much easier to monitor the status of many DB servers PUBLIC CONFIRMED Lecture http://www.pgcon.org/2010/schedule/events/216.en.html DMS 1140 Tatsuhito Kasahara