Hey everyone,
Could someone help understand the correlation between the quantity of relations and how much space they absorb in the Postgres? For example, 1k relations (permissions) is around 10MB of db size? I need to calculate how much space in DB my relations (permissions) will cost.
Thanks 🙂
v
vroldanbet
01/16/2024, 10:13 AM
I don't think we've formally published those numbers, but it it depends on your namespaces and object ID / subject IDs. I'd suggest running a quick experiment on an environment as close as to what you plan to run in prod, and query postgres for table sizes and infer that from your row count.
k
kotohoroshko
01/16/2024, 10:35 AM
I already think about that, but this is the last option. It would be interesting to have an etalon version
v
vroldanbet
01/16/2024, 11:10 AM
etalon version?
k
kotohoroshko
01/16/2024, 11:25 AM
The median value on which I could be oriented
v
vroldanbet
01/16/2024, 11:42 AM
unfortunately we don't have those values at the moment