Performance Tuning

Selected work in Performance Tuning, with its engagement context and
implementation review.

130 days of electricity data in 180 ms	/portfolio/a-month-of-meter-readings-in-180-milliseconds/	engineer.company	70
1Made a geographical data pipeline 50x faster	/portfolio/made-a-geographical-data-pipeline-50x-faster/	engineer.company	70
1Improved GIS map performance 10x on PostgreSQL	/portfolio/improved-gis-map-performance-10x-on-postgresql/	engineer.company	70
1Resolved 1,000 issues in geographical data	/portfolio/resolved-1000-issues-in-geographical-data/	engineer.company	70
1Ran 100 PostgreSQL, MS SQL, BigQuery warehouses	/portfolio/ran-100-postgresql-ms-sql-bigquery-warehouses/	engineer.company	70
1Ran 10 PostgreSQL and MS SQL servers on Ubuntu	/portfolio/ran-10-postgresql-and-ms-sql-servers-on-ubuntu/	engineer.company	70
1Accelerated PostgreSQL performance by 10x	/portfolio/accelerated-postgresql-performance-by-10x/	engineer.company	70
1Directed full‑stack GIS map development	/portfolio/directed-full-stack-gis-map-development/	engineer.company	70
1Overhauled internal processes, saving 8,000 hours	/portfolio/overhauled-internal-processes-saving-8000-hours/	engineer.company	70
1Saved 150 hours a month across 30 projects	/portfolio/saved-150-hours-a-month-across-30-projects/	engineer.company	70
1Administered 40 websites on Apache and Nginx	/portfolio/administered-40-websites-on-apache-and-nginx/	engineer.company	70
1Engineered 600 PL/pgSQL ETL/ELT pipelines	/portfolio/engineered-600-pl-pgsql-etl-elt-pipelines/	engineer.company	70
1Designed a JSON passthrough from Postgres to API	/portfolio/designed-a-json-passthrough-from-postgres-to-api/	engineer.company	70
1Time‑ordered keys for a growing data model	/portfolio/quicker-answers-from-a-better-choice-of-key/	engineer.company	70
1Modeled 348 tables across 34 Postgres schemas	/portfolio/modeled-348-tables-across-34-postgres-schemas/	engineer.company	70
1Built the Next.js 16 frontend: SSR, SSG and CSR	/portfolio/built-the-next-js-16-frontend-ssr-ssg-and-csr/	engineer.company	70
1Delivered full Progressive Web App support	/portfolio/delivered-full-progressive-web-app-support/	engineer.company	70
1Moved slow work onto a River job queue	/portfolio/moved-slow-work-onto-a-river-job-queue/	engineer.company	70
1Built fail‑closed rate limiting and anti‑abuse	/portfolio/built-fail-closed-rate-limiting-and-anti-abuse/	engineer.company	70
1Built first‑party analytics inside PostgreSQL	/portfolio/built-first-party-analytics-inside-postgresql/	engineer.company	70
1Built a loyalty wallet, leagues and badges	/portfolio/built-a-loyalty-wallet-leagues-and-badges/	engineer.company	70
1Public services on a small server	/portfolio/a-whole-company-on-one-small-server/	engineer.company	70
1Built dead‑man's‑switch host monitoring	/portfolio/built-dead-mans-switch-host-monitoring/	engineer.company	70
1Built a multilingual Hugo site in 3 languages	/portfolio/built-a-multilingual-hugo-site-in-3-languages/	engineer.company	70
1A safety net that no longer costs half an hour	/portfolio/a-safety-net-that-no-longer-costs-half-an-hour/	engineer.company	70
1Cut the stylesheet bundle from 87 KB to 31 KB	/portfolio/cut-the-stylesheet-bundle-from-87-kb-to-31-kb/	engineer.company	70
1Vendored a QR encoder in 522 lines	/portfolio/vendored-a-qr-encoder-in-522-lines/	engineer.company	70
1A bounded event pipeline for a macOS app	/portfolio/an-app-that-ate-41-mb-a-second-stopped/	engineer.company	70
1Adopted Swift 6 strict concurrency over C	/portfolio/adopted-swift-6-strict-concurrency-over-c/	engineer.company	70
1Took the test suite to 8.9 seconds	/portfolio/took-the-test-suite-to-8-9-seconds/	engineer.company	70

hThis page on the web	URL:https://engineer.company/categories/performance/	engineer.company	70
