News for hackers. Stuff that matters.
Re:Sharding and IDs at Instagram by mikeyk on Friday September 30, 2011 @05:57PM (#3058707)
(author here) I think this should also be possible with MySQL's stored functions, but one huge benefit to PostgreSQL is the schema/tablespace feature, since it means all our logical shards all live inside one database (you could do something similar with MySQL, but it would mean multiple databases or prefixing table names with the shard ID).
Re:Sharding and IDs at Instagram by HarrisonFisk on Saturday October 01, 2011 @01:07PM (#3060455)
PostgreSQL schemas are very similar to MySQL databases in functionality. In fact, in MySQL you can use SCHEMA in all places you can use the term database, ie. CREATE SCHEMA foo; instead of CREATE DATABASE foo;