# Performance Tuning

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

=> /portfolio/made-a-geographical-data-pipeline-50x-faster/ Made a geographical data pipeline 50x faster
=> /portfolio/improved-gis-map-performance-10x-on-postgresql/ Improved GIS map performance 10x on PostgreSQL
=> /portfolio/resolved-1000-issues-in-geographical-data/ Resolved 1,000 issues in geographical data
=> /portfolio/ran-100-postgresql-ms-sql-bigquery-warehouses/ Ran 100 PostgreSQL, MS SQL, BigQuery warehouses
=> /portfolio/directed-full-stack-gis-map-development/ Directed full‑stack GIS map development
=> /portfolio/overhauled-internal-processes-saving-8000-hours/ Overhauled internal processes, saving 8,000 hours
=> /portfolio/administered-40-websites-on-apache-and-nginx/ Administered 40 websites on Apache and Nginx
=> /portfolio/designed-a-json-passthrough-from-postgres-to-api/ Designed a JSON passthrough from Postgres to API
=> /portfolio/modeled-348-tables-across-34-postgres-schemas/ Modeled 348 tables across 34 Postgres schemas
=> /portfolio/built-the-next-js-16-frontend-ssr-ssg-and-csr/ Built the Next.js 16 frontend: SSR, SSG and CSR
=> /portfolio/delivered-full-progressive-web-app-support/ Delivered full Progressive Web App support
=> /portfolio/moved-slow-work-onto-a-river-job-queue/ Moved slow work onto a River job queue
=> /portfolio/built-fail-closed-rate-limiting-and-anti-abuse/ Built fail‑closed rate limiting and anti‑abuse
=> /portfolio/built-a-loyalty-wallet-leagues-and-badges/ Built a loyalty wallet, leagues and badges
=> /portfolio/a-whole-company-on-one-small-server/ Public services on a small server
=> /portfolio/built-a-multilingual-hugo-site-in-3-languages/ Built a multilingual Hugo site in 3 languages
=> /portfolio/a-safety-net-that-no-longer-costs-half-an-hour/ A safety net that no longer costs half an hour
=> /portfolio/cut-the-stylesheet-bundle-from-87-kb-to-31-kb/ Cut the stylesheet bundle from 87 KB to 31 KB
=> /portfolio/vendored-a-qr-encoder-in-522-lines/ Vendored a QR encoder in 522 lines
=> /portfolio/an-app-that-ate-41-mb-a-second-stopped/ A bounded event pipeline for a macOS app
=> /portfolio/adopted-swift-6-strict-concurrency-over-c/ Adopted Swift 6 strict concurrency over C

=> https://software.engineer.company/categories/performance/ This page on the web
