A few days ago, I faced sluggish search performance when querying a key in a table housing millions of indexed records, despite having optimized the indexing. However, employing range partitioning—a type of horizontal partitioning—proved to be the solution. By partitioning the data into distinct segments, the search process became more efficient and manageable.
- Docker (Documentation)
- Docker Compose
- Postgresql (Download)
- Node.js (Download)
- NPM (Will be download with Node.js)
- Backend - Nodejs + Postgresql ( http://localhost:3000 )
- Copy .env.example to .env
cp .env.example .env
npm run dev:docker
If you need to Re-Run docker, you should remove the container which was created before
npm run dev:docker:down