PG East 2011 will take place at the Hotel Pennsylvania in the heart of mid-town Manhattan on March 22 - 25, 2011. Celebrating nearly 15 years of PostgresSQL, programs are designed for administrators, developers, end-users and students, as well as IT decision-makers, and are designed to help attendees build skills, hear from peers and end users about their implementations, and network with the community leaders to discuss future product directions.
"With all of the changes in the open source database landscape, one constant has been the continued uptake and expansion of Postgres and it's userbase. PGEast as a result also continues to grow and gets better each year; and at this point I would say it's the premire event in the country for users, developers or those just starting to look into Postgres.” --Robert Treat
There is something for everyone at PGEast, from beginners to advanced users. OmniTI is excited to be participating again, with offerings for the beginner and intermediate user. Database Analyst Denish Patel; Database Architect and head of the Database Group, Robert Treat; and CEO Theo Schlossnagle will present four technical sessions and a half-day tutorial:
* P90X Your Database! Denish Patel. Obvious performance gain from shrinking bloated database is the driving factor to make database skinnier and faster in response time. This talk will explore ways to make your database skinnier for faster performance.
* Streaming databases: stepping outside of Postgres. Theo Schlossnagle. If you want the power of a complex database solution but have hundreds of thousands of new datum per second and need to run hundreds of thousands of queries per second it can become evident that a different approach is required. Introducing. . .Esper. Esper is a real-time streaming database (or CEP system) that allows running soft-real-time queries on streaming datasets. Esper is an excellent complimentary tool to Postgres and can completely alter the way you think about real-time data problems.
* Advanced WAL file management with OmniPITR. Robert Treat. Ever since the advent of PITR in Postgres 8.1, people have been creating one-off scripts designed to manage PITR and the xlog files that come with it. Finally, we decided we could do better, and OmniPITR was born. Designed to work with Postgres 8.2 and above, we've now replaced a whole mish-mash of scripts with something far more standard and re-usable. Cross platform and Postgres licensed, we have started to see more and more adoption outside of our client base, so we feel comfortable that it's a stable option for many of todays most demanding environments.
* The Essential PostgreSQL.conf, Robert Treat. While Postgres is generally considered easy to administer, these days it's config file contains hundreds of variables, which many find rather daunting. In this talk, attendees will review a break down the major areas that most people need to know about, and then discuss the config variables they'll most likely need to know.
* Pro PostgreSQL 9. A half-day training session with Robert Treat. From start-ups to large enterprise shops, more and more people are using Postgres. Whether as a self-running data store, or to handle more complex OLTP, OLAP, and mixed database workloads, Postgres offers a lot of functionality and flexibility. What it doesn’t offer is a road map of how to go beyond the basics and get the information necessary to go from just another user to serious PostgreSQL professional.
For more agenda information and to register, please visit: https://www.postgresqlconference.org/