/citus-postgresql

Horizontal PostgreSQL v11 Scaling using Citus

Primary LanguageJavaScript

Horizontal PostgreSQL v11 Scaling using Citus

This is a proof-of-concept for a PostgreSQL logical+phsyical sharding strategy. This utilizes the Citus Community software.

Usage: TODO Requirements:

Usage:

  1. Start up the Docker stack:
$ docker-compose up -d

  1. Wait until you see the Listening on port 5555... message in the server container logs

  2. Kick off fake data population:

$ curl http://localhost:5555/populate

  1. Wait until you see the Done populating DB! message in the server container logs (this will take a while)

  2. Browse the DB via:

$ docker-compose exec master psql -U postgres