
我从1996年开始使用Postgres 1.01,当时我正在寻找具有与我在工作中使用的商业数据库类似的功能的东西,例如Informix和Ingres。我尝试了mSQL(Mini SQL),但是它当时甚至没有简单的功能,但Postgres具备了。当时我最想知道数据库是如何内部工作的,而不是实际使用Postgres。
I started in 1996, with Postgres 1.01. I was looking for something with features similar to the commercial databases I used at work, like Informix and Ingres. I tried mSQL, but that didn't have even simple features, but Postgres did. I was mostly curious to see how databases worked internally, rather than having a practical use for Postgres.
人们通常将重点放在Postgres的技术功能上,但是这些功能来自健康的社区。我认为Postgres之所以出色,不是因为其功能强大,而是因为它充满活力的鼓励卓越的社区,进而创造出卓越的功能。
People often focus on the technical capabilities of Postgres, but those features come from a healthy community. I think Postgres is good not because of its features, but rather because of its vibrant community that encourages excellence, which then generates great features.
嗯,我喜欢对btree索引条目进行重复数据删除。这为低基数列提供了类似于位图索引的功能,而没有位图索引的缺点。
Uh, I like the deduplication of btree index entries. This allows something similar to bitmap indexes for low cardinality columns without the downsides of bitmap indexes.
我认为我们最重要的是分片和透明数据加密。
Zheap,以及更好的启用校验(checksums)而不需要停机也很重要。
I think our big ones are sharding and transparent data encryption.
Zheap and better ability to enable checksums without downtime are also important.
是的,我都读了。我确实有一个有关使用电子邮件和网络论坛的博客条目:
https://momjian.us/main/blogs/pgblog/2018.html#January_5_2018
Yes, I read them all. I do have a blog entry about the use of email and web forums:
https://momjian.us/main/blogs/pgblog/2018.html#January_5_2018
好吧,有一个核心团队,主要专注于治理。然后我们负责代码提交的团队负责处理对源代码的更改。我们有处理提交请求的commit-fest 管理员。我们有一个负责发布的发布管理团队,以及一个负责调查的行为准则委员会。每个地理区域都有其自己的用户群体,这有助于促进其所在地区的活动。
Well, there is the core team, which mostly focuses on governance. The source code committers deal with changes to the source code. We have commit-fest managers that handle commit requests. We have a release management team that deals with releases, and a code of conduct committee that deals with investigation. Each geography has its own user group society that helps promote activity in their region.
嗯,我只是社区中许多领导者之一。我在EnterpriseDB的工作确实是为了促进Postgres社区的健康,因此这两个工作确实有相同的目标。
Uh, well, I am just one of many leaders in the community. My job at EnterpriseDB is really to promote the health of the Postgres community, so the two jobs really have the same goal.
好吧,去年的巴厘岛很不错,我对俄罗斯的所有访问都令人难忘。日本也很有趣,我真的很喜欢去中国的乌镇。
Well, Bali last year was nice, and all my visits to Russia are memorable. Japan is also enjoyable to visit, and I really enjoyed visiting Wuzhen, China.
我很高兴看到现在有许多来自中国的社区活动。我一直希望如此,并且希望它继续下去。
I am excited to see lots of community activity now coming from China. I have been hoping for this for a long time and I hope it continues.
嗯,我实际上很喜欢旅行,所以我的工作和娱乐都一样。我也喜欢阅读许多主题的非小说类书籍。
Uh, I actually love to travel, so my work and enjoyment are kind of the same. I also enjoy reading non-fiction books on many topics.
确实有人提出过要求,但是我们无意更改它,甚至我们认为我们根本就无权修改它
People have asked that and we have no intention of ever changing it, and we don't even think we have the right to change it.
Bruce Momjian 认为分片和透明数据加密是PostgreSQL未来最重要的发展方向。关于分片,北京时间5月16日(周六)上午9点30,Bruce将作客中国PsotgreSQL分会《大咖面对面》,直播带你探讨未来的PostgeSQL分片。
分享大纲:
1. Scaling 扩展
2. Vertical scaling options 垂直扩展选项
3. Non-sharding horizontal scaling 非分片水平扩展
4. Existing sharding options 现有的分片选项
5. Built-in sharding accomplishments 内置的分片功能
6. Future sharding requirements 未来的分片需求
除了嘉宾原汁原味的英文技术分享,我们还将PPT做了中英文对照。除此之外,还准备了10个PostgreSQL定制迷你加湿器,直播现场抽奖送出。





