Option 2 has many unforeseen consequences. Business wants to run a query across ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		outworlder on April 13, 2022 \| parent \| context \| favorite \| on: Inside the longest Atlassian outage Option 2 has many unforeseen consequences. Business wants to run a query across customers? In most DBs you need either custom code or to create a stored procedure to iterate across schemas. Every table that you create is multiplied by the number of customers. This has implications for some database systems (like PG's vacuum). Your migrations will take _forever_ to run. Etc.

Spivak on April 13, 2022 [–]

The second problem is mitigated by the fact that schemas are trivially migratable between database servers. Once you grow too big for one cluster just make another.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact