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.