PGCon2010 - Final Release III
PGCon 2010
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Gleb Arshinov |
|
Oleksandr Dymo |
| Schedule | |
|---|---|
| Day | Talks - 2 - 2010-05-21 |
| Room | DMS 1140 |
| Start time | 11:30 |
| Duration | 01:00 |
| Info | |
| ID | 210 |
| Event type | Lecture |
| Track | Applications |
| Language used for presentation | English |
PostgreSQL as a secret weapon for high-performance Ruby on Rails applications
This session will cover lessons learned about Ruby on Rails development using PostgreSQL. From the database-centric view the session will explain Rails best practices, taking advantage of RoR strong points, dealing with its weak points, PostgreSQL strong and weak points, and using advanced SQL features in web applications. The session will demonstrate how PostgreSQL is used to speedup Rails code, making slow things in your web application fast and impossible things - possible. The session will also discuss the peculiarities of complex enterprise apps and show that PostgreSQL is an ideal open source match for their development.
Topics covered will include:
Our experience with Ruby on Rails and PostgreSQL combo: - performance characteristics of Ruby applications - Rails advantages - PostgreSQL advantages
How to optimize Rails with PostgreSQL: - doing as much as possible in SQL - preloading attributes and associations - using Postgres' arrays for even faster preloading - generating and executing SQL queries instead of manipulating data with ORM
How to optimize Rails application by moving logic to the PostgreSQL database: - efficient trees - efficient pagination - efficient access control system with roles and privileges - efficient data analysis and aggregation
How to deal with PostgreSQL limitations: - optimizer forcing subselects for the whole result set despite limit/offset - optimizer not being able to estimate the resulting set size of the generate_series() function call - "in" in where conditions forcing joins - need for pushing down conditions in certain cases - avoiding on-disk sorts - selecting records holding group-wise maximum without windowing functions (pre 8.4) - using "not exists" as a cure to bad performance of "not in" conditions
How to make your database faster: - improving shared database performance under severe memory restrictions - realistic explain analyze - Postgres-specific performance tips
How to keep your database and application robust: - getting the right compromise between ORM and the database - best practices for database schema development and maintaining data integrity - performance testing and benchmarking - performance monitoring