HackerTrans
TopNewTrendsCommentsPastAskShowJobs

x4m

143 karmajoined 15 tahun yang lalu
Postgres Hacker

Submissions

Unmerged Patches and Useful Failures: My Journey to Postgres Major Contributor

medium.com
9 points·by x4m·5 bulan yang lalu·2 comments

comments

x4m
·11 jam yang lalu·discuss
Just use https://github.com/yandex/odyssey :) It's a scalable PgBouncer.
x4m
·5 bulan yang lalu·discuss
I'd love to! But MySQL is developed inside Oracle, and OCA somewhat scares me. Perhaps, I'll give a try to MariaDB or other forks.
x4m
·6 tahun yang lalu·discuss
Thanks for the post, great read! Just one minor note s/Odessey/Odyssey/g // From Odyssey maintainer
x4m
·7 tahun yang lalu·discuss
My name is Andrey, I'm an engineer. I'm contributing to PostgreSQL on behalf of Yandex.Cloud. Also, I'm working on WAL-G. I like jogging and quake[2,3]. Not sure what else defines me...
x4m
·7 tahun yang lalu·discuss
Sounds cool, but I doubt it is implementable... Let's create an issue for discussion of this feature?
x4m
·7 tahun yang lalu·discuss
We have GCP. There's a PR https://github.com/wal-g/wal-g/pull/189/commits/17363c3fb6a5...

I'm on-call for this week, but I'm planing to work on merging this soon.
x4m
·7 tahun yang lalu·discuss
If your DB is under few TB, you, probably, can go with WAL-E. We have thousands of clusters with total amount around 1PB of data. WAL-G is simple to set up, but current CLI experience is far from perfect.

Our goal is to make the most performant PostgreSQL backup system for cloud deployments. WAL-G is not just fast compression tool: we parallelize serial archive\restore interface and provide very cheap delta-backups. In PostgreSQL, you usually have PITR through WAL. If you have rare backups, your restore time is slow: WAL is applied serially. With WAL-G you can have delta-backups often, they are applied in parallel and much faster than WAL. This is important for us, because we have a bunch of distributed datacenters and from time to time we need to repair HA clusters from backups as fast as we can.

Best regards, Andrey.