It was my understanding that PostgreSQL supports table sharding out of the box on a single instance but not the ability to do distribute the processing across multiple instances.
429 karma · joined April 26, 2021
$5/sq inch and you get 3 copies of your board
'Only use novel things that are actually needed and can be accomplished in a reasonable time frame'
Good advice and I like the novel the argument approach.
You an author or something?
The textbook case would be student IDs in a university database where each row corresponds to a single student. However some universities view the student id as sensitive information (kind of like a ssn in the US) and so in that scenario it should be aliased to some other key to prevent the student id from being present in multiple tables as a foreign key.