Tag: postgresql
All the articles with the tag "postgresql".
Page 1 Was Fast. Page 400 Timed Out.
Offset pagination has to produce every row it discards, and the fix has three parts that only work together: the sort key, the cursor, and the index.
We Deleted Old Readings Every Night. That Was the Expensive Part.
A telemetry table that only grows forces three decisions: how you remove data, how many resolutions you keep, and what happens when a device reconnects and replays six hours of buffer.