PostgreSQL Tips and Tricks for Developers

The roles between the developer and the DBA is often blurred. This paper covers many tips and tricks a developer can use to improve and optimise an application by understanding and writing better SQL. It also covers basic PostgreSQL optimisation and tuning as the default system (freshly installed) is not well configured for modern hardware.

Course Slides