PGCon2013 - Final Release

PGCon 2013
The PostgreSQL Conference

Susanne Ebrecht
Day Talks - Day 2 - 2013-05-24
Room MNT 202
Start time 15:00
Duration 01:00
ID 561
Event type Lecture
Track Applications
Language used for presentation English

SQL hints, tips, tricks and tuning

Performance tips and tricks on SQL level.

What is the difference between inner, outer, cross and natural join? What is a correlated subselect? What is the advantage and what the disadvantage of an index. Is NOT and OR evil? When do I need normalisation and when denormalisation? All this questions and lots of other performance tips and tricks on SQL level will be given in the talk.