Videos are now up for the pgDay.
pgDay San Jose 2009
Thanks to generous sponsors O'Reilly and Associates, EnterpriseDB and Aster Data, we will be having a full day of PostgreSQL talks at the San Jose Convention Center immediately before O'Reilly Open Source Conference (OSCON). Join us and learn lots about PostgreSQL, the new Version 8.4, and database application design!
- When: Sunday, July 19th, 2009
- 9:30am to 9pm
- Where: San Jose Convention Center, Rooms B1 & B4
- Followed by a party at the Britannia Arms Downtown
Registration is free, but you must RSVP on the Meetup Page for the pgDay. Note that registration for the 8.4 Party is separate.
All attendees are encouraged to donate to PostgreSQL.org so that we can hold more events in the future.
|10:15||Version 8.4: Easier to Administer than Ever||Josh Berkus||PostgreSQL Experts|
|10:45||Rapid Upgrades with pg_Migrator||Bruce Momjian||EnterpriseDB|
|11:15||Coffee Break||Sponsored by|
|11:35||Check Please! What Your Postgres
Databases Wishes You Would Monitor
|1:45pm||PostgreSQL Pitfalls||Jeff Davis||Truviso|
|2:35pm||What works with Postgres
The Open Geo Data
|Brian Hamlin||OSGeo Foundation|
|3:20pm||Coffee Break||Sponsored by|
|3:40pm||Very Large Databases and PostgreSQL
Issues and Solutions
|John Cieslewicz||Aster Data|
|4:25pm||pgGearman: A distributed
worker queue for PostgreSQL
|7:00pm||PostgreSQL 8.4 Party||Everybody||Sponsored By|
San Jose Convention Center
San Jose McEnery Convention Center
150 West San Carlos St.
San Jose, CA 95113
We will be in rooms B1 and B2, which are on the Exhibit Level on the Market Street side of the Convention Center. See Convention Center Map. At this time, we don't now which entrances will be open on Sunday.
Britannia Arms Downtown
Downtown Britannia Arms
173 W. Santa Clara St.
San Jose, CA 95113
From 7pm onwards, we will be celebrating the release of version 8.4 (hopefully) of PostgreSQL at the Britannia Arms. It is located a few blocks away from the convention center. See Party Details below. Note that this is not the Britannia Arms Almaden, which is in another part of San Jose.
Walking Directions from SJCC and Train Directions
pgDay San Jose would not be possible without the generous help of the following sponsors:
O'Reilly and Associates, publishers and conference organizers of open source and technology content everywhere including OSCON, have generously provided space for the pgDay San Jose.
EnterpriseDB, makers of Postgres Plus and Advanced Server as well as major sponsors of the PostgreSQL project, are sponsoring the pgDay San Jose to make a celebration of version 8.4 possible.
Aster Data, makers of Aster nCluster, not only allow PostgreSQL to scale to petabytes of data, but have also made our coffee breaks possible for the pgDay.
Chanticleer Films produces and publishes video for all San Francisco PostgreSQL events.
O'Reilly Open Source Conference is the most prominent open source software developer conference in the United States. It attracts thousands of open source developers every year for two days of tutorials and three days of talks. OSCON will be held at the San Jose Convention Center immediately after pgDay San Jose.
The main OSCON program includes several talks about PostgreSQL and PostGIS, and even more talks about database application design in general. Registration is still open; if you are excited about pgDay San Jose, you should plan to go to OSCON as well.
PostgreSQL 8.4: Easiest to Administer Ever
This half-hour talk will focus on the new features of version 8.4 which make PostgreSQL easier to install, configure, monitor and troubleshoot than it has ever been before. With demos of some features.
Josh Berkus is on the PostgreSQL Core Team, and is also CEO of PostgreSQL Experts Inc.
Rapid Upgrades With Pg_Migrator
This talk is about pg_migrator, a tool that allows upgrades from Postgres 8.3 to 8.4 without a dump/restore. The talk will explain how pg_migrator works and includes performance metrics. A live demo will show how to upgrade a database.
Bruce Momjian is a co-founder of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996. He is the author of PostgreSQL: Introduction and Concepts, published by Addison-Wesley. Bruce is employed by EnterpriseDB.
Check Please! What Your Postgres Databases Wishes You Would Monitor
Compared to many proprietary systems, Postgres tends to be pretty straight foward 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.
Robert Treat leads the database operations group at OmniTI, one of the worlds premiere internet consulting agencies, running some of the largest and high rate OLTP Postgres systems around. Robert is a recognized expert within the open source database industry, speaking at various international conferences, and maintaining a popular blog at http://www.xzilla.net/.
This talk warns of the edge cases in PostgreSQL that can get you into trouble. The examples span from simply unintuitive behavior to the gory implementation details (like snapshot isolation) that leave real problems at the surface. Application programmers and DBAs alike should be aware of these pitfalls, know how to work around them, and know that most of these problems aren't unique to PostgreSQL.
Jeff Davis is a software engineer at Truviso, Inc., a streaming database system company. He has been a PostgreSQL community member since 2000, and he contributed the Synchronized Scan feature for PostgreSQL 8.3.
What works with Postgres - the Open Geo Data Interoperabilty Overview
Stacks Make Apps
The Open Source Geospatial Foundation (OSGeo) is home to a bevy of open standards, OSS licensed projects, many of which offer interoperability with Postgres and especially PostGIS. Presented is an overview of a number of working stack components you can use today for Geo-aware end-user solutions.
Brian Hamlin is a founder of the California chapter of the OSGeo Foundation, and a professional developer of custom Geo applications.
Very Large Databases and PostgreSQL: Issues and Solutions
Description TBA this week.
pgGearman: A distributed worker queue for PostgreSQL
Brian Aker and Eric Day will present their work on Gearman, a distributed worker queue which load-balances tasks over a cluster of servers, and PGGearman, the PostgreSQL interface to Gearman. With PGGearman, it will be possible to "farm out" CPU-intensive tasks to a cluster of servers from inside the database, or even send tasks to another database server.
Brian Aker is one of the key architects of MySQL, and now leads both the Drizzle and Gearman projects in an effort to bring open source data technology to cloud architectures. Eric Day is a major contributor to the Gearman and Drizzle projects. They both work for Sun Microsystems.
For five minutes each, speakers will present a bevy of tools, ideas, solutions and extensions to PostgreSQL and complimentary technologies. We still have a few slots open, so contact us if you want to present!
- Lightning Talks: David Fetter
- Add Constraints for Performance: Jeff Davis (Talk Slides)
- OpenStreetMap: Russ Nelson
- The Tungsten Platform & Londiste: Robert Hodges
- PL/R: Joe Conway
- Open Database Alliance: Monty Widenius
- Code Scan: David Maxwell
- User Groupalooza: Selena Deckelmann
The 8.4 Party will be at the Britannia Arms Downtown (see above) about 6 blocks from the Convention Center. We will have the entire patio, and will be serving free beer (yaaay, free as in beer) to everyone who RSVPs, as well as snacks. The party will start at 7pm and run until whenever.
All attendees at the pgDay are invited, as well as other open source people attending OSCON or in the San Jose area. However, you must RSVP on our Meetup Page for the party.
For people coming from the Convention Center, we will meet outside the Market Street entrance at 6:30pm and walk over to the Britannia Arms in a group.
Josh Berkus, David Fetter, Robert Hodges, Miho Ishakura, Bruce Momjian, Elein Mustain, Githogori Nyangara-Murage, Robert Treat