PgDaySanJose2009

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!
== Details ==
* 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 ==
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.
== Schedule ==
Time 	Talk 	Speaker 	Company
9:45 	Introduction 	pgDay Committee 	
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 byAster Data
11:35 	Check Please! What Your PostgresDatabases Wishes You Would Monitor	Robert Treat 	OmniTI
12:20 	Lunch Break 	 	
1:45pm	PostgreSQL Pitfalls 	Jeff Davis 	Truviso
2:35pm	What works with PostgresThe Open Geo DataInteroperabilty Overview 	Brian Hamlin 	OSGeo Foundation
3:20pm	Coffee Break 	 	Sponsored byAster Data
3:40pm	Very Large Databases and PostgreSQLIssues and Solutions 	John Cieslewicz 	Aster Data
4:25pm	pgGearman: A distributedworker queue for PostgreSQL 	Brian AkerEric Day	Gearman Project
5:15pm	Lightning Talks 	Various 	Various
7:00pm	PostgreSQL 8.4 Party 	Everybody 	Sponsored ByEnterpriseDB
== Locations ==
=== 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
(408) 278-1400
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
== Sponsors ==
pgDay San Jose would not be possible without the generous help of the following sponsors:
=== Venue Sponsor ===
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.
=== Platinum Sponsor ===
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.
=== Break Sponsor ===
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.
=== Media Sponsor ===
Chanticleer Films produces and publishes video for all San Francisco PostgreSQL events.
== OSCON Information ==
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.
== Talk Details ==
=== 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/. 
=== PostgreSQL Pitfalls ===
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.
=== Lightning Talks ===
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 ()
* 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
== Party Details ==
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.
== Organizing Committee ==
Josh Berkus, David Fetter, Robert Hodges, Miho Ishakura, Bruce Momjian, Elein Mustain, Githogori Nyangara-Murage, Robert Treat
Category:PostgreSQL Events