openpolitics.com

  • writing
  • quotes
  • Topics
    • academia
    • corruption
    • economics
    • education
    • environment
    • finance
    • history
    • hypertext
    • media
    • philosophy
    • psychology
    • religion
    • russia
    • ted nelson
  • about

Sharding a multi-tenant app with Postgres

Co-locating data within the same physical instance avoids sending data over the network during joins. This can result in much faster operations. With Citus there are a number of ways to move your data around so you can join and query it in a flexible manner, but for this class of multi-tenant SaaS apps it’s simple if you can ensure data ends up on the shard.



Source:

Tags: citris-database, database, postgres, scalability, sharding

Read More

Interesting Links:

  • Beau of the Fifth Column
  • René Girard: 5-part CBC Interview Series

Tim Langeman © 2023 · Genesis Framework · WordPress · Log in

Click to access the login or register cheese