February 15, 2011 · 6:15 PM
The new features available in PostgreSQL 9, open up new possibilities for designing high-performance web applications. Some examples are running heavy analytical queries on a read-only slave production database, or diverting read-only traffic to a slave database to help improve web response time. In this talk, I will discuss some ways a production environmentcan be setup with PostgreSQL 9 to enable better performance on web applications while not distorting the development environment. Additionally, I will demonstrate some other tools that can be used in conjunction with PostgreSQL 9 features, including Sphinx, a full-text indexing and combine it with a hot-standby to maximize performance. Talk given by Jonathan Katz Room open at 6:15 pm, talk starts at 6:30 pm.