HackerTrans
TopNewTrendsCommentsPastAskShowJobs

x4m

143 karmajoined 15년 전
Postgres Hacker

Submissions

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

medium.com
9 points·by x4m·5개월 전·2 comments

comments

x4m
·7시간 전·discuss
Just use https://github.com/yandex/odyssey :) It's a scalable PgBouncer.
x4m
·5개월 전·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년 전·discuss
Thanks for the post, great read! Just one minor note s/Odessey/Odyssey/g // From Odyssey maintainer
x4m
·7년 전·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년 전·discuss
Sounds cool, but I doubt it is implementable... Let's create an issue for discussion of this feature?
x4m
·7년 전·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년 전·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.