Ingesting lots of timeseries data

From PgConf NYC 2025

1. Choose the right Data Types SMALLINT vs BIGINT, or just INT

2. BRIN Indexing

Declarative Partioning: - Range Partitioning # perfect for timeseries data

I kinda gave up on notetaking. I feel like anytime I'm asked to do a lot of things versus just trying timescaleDB (or some other extension that makes life easy) I checkout.