PGCon2013 - includes video

PGCon 2013
The PostgreSQL Conference

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

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.