Catalogue

Cards
165
Records
486
Workloads
19
Corpus version
74847648e25a
Workload
Kind
Setup

12 of 486 records match.

KindRecordOrganisationYearSetup
Decision

Batch ping writes with COPY in one transaction instead of calling a stored procedure once per ping

healthchecks-2025-ping-ingest#d1peak under 100,000 requests/s

Healthchecks.io2025One database
Decision

Cache not-found results for UUID ping URLs so repeated pings to missing checks skip the database

healthchecks-2025-ping-ingest#d2peak under 100,000 requests/s

Healthchecks.io2025One database
Decision

Stop using DynamoDB and serve key/value lookups, ingest and rate limiting from one fixed-size SingleStore cluster

fathom-2021-singlestore-database#d1

Fathom Analytics2021One database
Decision

Keep database connections open by moving the dashboard and queue off per-request Lambda connections

fathom-2021-singlestore-database#d2

Fathom Analytics2021One database
Failure

A viral customer's pageviews backlog the shared queue for all sites while the database runs out of disk IOPS

fathom-2020-viral-customer-backlog#f1

Fathom Analytics2020One database
Failure

Unindexed backlog tables and a text-typed site ID kept the database slow after the disk was fixed

fathom-2020-viral-customer-backlog#f2

Fathom Analytics2020One database
Decision

Cap concurrent queue workers on purpose to protect the database, accepting a bigger backlog

fathom-2020-viral-customer-backlog#d1

Fathom Analytics2020One database
Decision

Limit pageviews processed per site per minute so one viral site cannot block the rest, then drop it

fathom-2020-viral-customer-backlog#d2

Fathom Analytics2020One database
Failure

A hundred checker Lambdas each opened a database connection at once, and Postgres refused further connections

onlineornot-2023-lambda-write-fan-in#f1

OnlineOrNotOne database
Decision

Fan results in through SNS and a batching queue so one Lambda writes to Postgres, instead of upgrading the database

onlineornot-2023-lambda-write-fan-in#d1

OnlineOrNotOne database
Decision

Migrate the Energy analytics database from multi-AZ Postgres RDS to Aurora for elastic storage

gridium-2021-aurora-migration#d1

GridiumOne database
Decision

Upsize the Aurora writer for buffer cache, route reads to a downsized replica, and run pg_repack on bloated tables to cut billed I/O

gridium-2021-aurora-migration#d2

GridiumOne database