3 ms·
I tried putting Postgres on JuiceFS and let's just say.. it didn't perform very well
by Jamie9912 4y ago
I tried putting Postgres on JuiceFS and let's just say.. it didn't perform very well
- mbreese 4y agoIs that a use case they are really targeting though? Their splash page mentions big data with model generation and genomic sequencing as examples. I can really only speak to genetic sequencing. The IO pattern for these workflows is almost all streaming reads/writes. Random access takes too long when you are reading/writing 100-500GB files. Postgres doesn’t like running on NFS either to be fair.
- daviesliu 4y agoYes, JuiceFS is not a good choice for PG, unless if you don't care the performance. One interesting use case is the backup of MySQL [1]. [1] https://juicefs.com/docs/cloud/backup_mysql_in_juicefs/ https://juicefs.com/docs/cloud/backup_mysql_in_juicefs/
- lillecarl 4y ago> Postgres doesn’t like running on NFS either to be fair. https://news.ycombinator.com/item?id=19119991 https://news.ycombinator.com/item?id=19119991 Is that still the case after this? Or is it tribal knowledge?
- prpl 4y agopostgres + rocks fdw would be a more interesting test case (or any LSM DB)