Speaker Interview with Bruce Momjian
- Community roadmap to sharding
- Thursday 10:30
- Washington
- Could you briefly introduce yourself?
- I am a Postgres core team member, and have been working on Postgres for 23 years. I am an EnterpriseDB employee.
- How do you engage with the PostgreSQL Community?
- I read lots of email, and visit many Postgres events every year.
- Have you enjoyed previous pgconf.eu or FOSDEM conferences, either as an attendee or as speaker?
- Sure, I think I have been to most pgconf.eu conferences, and a few FOSDEM ones.
- What will your talk be about, exactly? Why this topic?
- I will be presenting a talk with Alexander Korotkov about adding built-in sharding to Postgres. It allows multi-host Postgres where the data is sharded across multiple servers. It is good for write-scaling, and petabytes of data.
- What is the audience for your talk?
- People interested in very high scaling of Postgres.
- What existing knowledge should the attendee have?
- It would be helpful to understand the general things that limit relational database performance. Knowledge of transaction control, partitioning, and foreign data wrappers would help.
- What is the one feature in PostgreSQL 12 which you like most?
- Multi-column most-common-value statistics
- Which measure, action, feature or activity would—in your eyes—help to accelerate the adoption of PostgreSQL?
- I think sharding is important, as is transparent data encryption. I am working on both of these.