Like any sharp implement, the power and flexibility of PostgreSQL can be dangerous if mishandled. Drawing on real-life queries from real-life clients (names and schemas changed to protect the innocent), we'll talk about 10 easy query and configuration techniques you can use to destroy your PostgreSQL performance... or, if you really want to, improve it, too.
This talk explores the much-anticipated Postgres 9.0 features of hot standby and streaming replication. It explains how these features work, how to configure them, and their current limitations. It includes a hands-on demonstration that can be done either by the instructor or by students.
An introduction to advanced analytics from within PostgreSQL using R
R is the leading free software environment for advanced mathematical and statistical computing and graphics. PL/R is a PostgreSQL extension that allows the use of R from within PostgreSQL for advanced analytics in a simple, efficient, and controlled manner. This presentation will introduce the audience to PL/R, starting with installation on various OS's, and taking them through basic, and a few more advanced, examples of its power.
How the City of Garden Grove takes advatage of PostgreSQL
Local governments deliver important services to residents, businesses, and visitors: Water, sewer, roads, land use, police, fire, environmental compliance, are some of services that cities routinely provide. Garden Grove, a full service city of over 172,000 residents in Orange County has taken advantage of Open Source since 1995. PostgreSQL increasingly helps solve the City’s business needs. The talk will cover how cities generate lots of varied and interesting data and outline how PostgreSQL is used in Garden Grove developed Ruby on Rails applications as well as a number of commercially available applications. Ruby on Rails tends to treat databases as “bit buckets” but the framework can be easily integrate many of Postgres’ powerful features if handled correctly. City developed applications include police records management, utility billing, and parks and recreation management.
The California Public Utility Commission recently funded a project to process a very large energy efficiency dataset. Various free & open source projects including PostgreSQL were utilized. This talk will detail the reasoning behind the decision to use the FLOSS software as well as any issues that came up.