Arcaik,
@Arcaik@mastodon.social avatar

@renchap @thisismissem @hrefna @Gargron Not really. DB migrations put aside, the main thing the application has to do is to add the partition key into the where clause to ensure performances stay good.

e.g. if you partition table toot by user_id, you have to run something like SELECT message FROM toots WHERE toot_id = foo AND user_id = bar.

This prevents the query planner from scanning all the sub tables.

  • All
  • Subscribed
  • Moderated
  • Favorites
  • random
  • uselessserver093
  • Food
  • aaaaaaacccccccce
  • test
  • CafeMeta
  • testmag
  • MUD
  • RhythmGameZone
  • RSS
  • dabs
  • KamenRider
  • Testmaggi
  • KbinCafe
  • Ask_kbincafe
  • TheResearchGuardian
  • Socialism
  • oklahoma
  • SuperSentai
  • feritale
  • All magazines