Skip to content

DEV Community

Postgres through the looking glass Series' Articles

Back to Mircea Cadariu's Series

Cover image for To UUID, or not to UUID, that is the primary key question

Feb 2 '24

To UUID, or not to UUID, that is the primary key question

#postgres #sql #database #performance

8 min read

Cover image for Query optimisation guided by explain plans

Apr 3 '24

Query optimisation guided by explain plans

#sql #performance #postgres #database

12 min read

Cover image for Faster table joins

Sep 2 '24

Faster table joins

#postgres #performance #sql #database

7 min read

Cover image for High speed data loading into Postgres

Feb 4

High speed data loading into Postgres

#database #postgres #performance #sql

6 min read

Oct 7

The unreasonable effectiveness of Postgres range types

#postgres #database #data #webdev

4 min read

Cover image for Postgres Column Tetris

Oct 14

Postgres Column Tetris

#database #postgres #webdev #programming

4 min read

Nov 15

Postgres tuning using feedback loops

#database #postgres #programming #resources

2 min read