# Database performance rescue for Stridewell

> Diagnosed and fixed PostgreSQL bottlenecks that were timing out the busiest pages.

URL: https://freelance.adscaled.media/freelancers/tomasz-kowalczyk/work/database-performance-rescue-for-stridewell

Diagnosed and fixed PostgreSQL bottlenecks that were timing out the busiest pages. A case study by Tomasz Kowalczyk, Backend Engineer (Go & PostgreSQL).

## Challenge

Stridewell, a running shoe retailer, saw pages time out every Monday morning when usage peaked. The team had doubled the database size twice and the problem kept coming back.

## Solution

I analysed slow-query logs and query plans, added five targeted indexes, rewrote the three worst queries, removed an N+1 pattern in the ORM and introduced a read replica for reporting. The database was then sized back down.

[View Tomasz Kowalczyk’s profile](https://freelance.adscaled.media/freelancers/tomasz-kowalczyk)

---

Taskora is a demo product by AdScaled. Profiles, jobs, reviews and payments are fictional; no real money moves.

## Site navigation

- [Find talent](https://freelance.adscaled.media/talent.md)
- [Find work](https://freelance.adscaled.media/jobs.md)
- [Categories](https://freelance.adscaled.media/categories.md)
- [How it works](https://freelance.adscaled.media/how-it-works.md)
- [Pricing](https://freelance.adscaled.media/pricing.md)
- [Trust & Safety](https://freelance.adscaled.media/trust.md)
- [Blog](https://freelance.adscaled.media/blog.md)
- [About](https://freelance.adscaled.media/about.md)
- [Contact](https://freelance.adscaled.media/contact.md)
- [Help center](https://freelance.adscaled.media/help.md)
- [Privacy Policy](https://freelance.adscaled.media/privacy.md)
- [Public API documentation](https://freelance.adscaled.media/api/docs)