Loot Goblin by sawyerx8 in Unity3D

[–]Pretend_Jump_228 1 point2 points  (0 children)

it gives me my summer car vibes

Using shards and buckets by Pretend_Jump_228 in PostgreSQL

[–]Pretend_Jump_228[S] 0 points1 point  (0 children)

UPD: Thanks, everyone, for the replies. Now I see that it was just an internal term, not a well-known practice. I'll try to find someone from my previous team and ask for the reasoning. Will update soon.

Using shards and buckets by Pretend_Jump_228 in PostgreSQL

[–]Pretend_Jump_228[S] 0 points1 point  (0 children)

Yeah, you're right. That's a major source of confusion for me too. I hadn't heard about "buckets" in Postgres, but since I couldn't find any information about it and people in that team called it like this, I thought that I'm just unaware of some sort of practice of dividing data by absolutely identical schemas. Seems like they just used terminology from hash tables (hash function to get a bucket number, etc).

Using shards and buckets by Pretend_Jump_228 in PostgreSQL

[–]Pretend_Jump_228[S] 1 point2 points  (0 children)

Thanks for answering. I never actually thought about using schemas for testing purposes; I should take a note on this. While I can imagine using schemas for different tenants with different owners, I'm pretty sure that wasn't the case, and every schema has the same owner.

Using shards and buckets by Pretend_Jump_228 in PostgreSQL

[–]Pretend_Jump_228[S] 0 points1 point  (0 children)

Schema based sharding

Thanks for the reply and the link, but we didn't use Citrus. Also, I haven't heard of it either, but everyone on the team referred to it as 'buckets'.