img

General guidelines for PostgreSQL database architecture.

Some general guidelines for PostgreSQL database architecture to ponder about. The content is too large to post here, so I put it in a PDF that you can download here

Subject overview:

Naming things

Datatypes to avoid

Store your data in the appropriate datatypes

Be aware of the limits of some datatypes

Column-order matters

Find bottlenecks and warnings

Normalization

Business logic

Maintenance

Indexes



Ellert van Koperen, April 2024.