Mark Wong is a Software Development Engineer at EDB and is a PostgreSQL Major Contributor. He first introduced himself to the PostgreSQL community in 2003 with open source benchmarking kits and performance data. Since then, he has continued to contribute to various aspects of the community such as a Google Summer of Code mentor, Conference Organizer, Portland PostgreSQL Users Group Co-Organizer, PostgreSQL Fundraising Group Member, and a Director on the Board of the United States PostgreSQL.
Presentations
PostgreSQL Ask Me Anything
Various PostgreSQL community members attend SCaLE and are willing to meet with attendees and answer any questions. Many aspects of the community are covered: User groups, conference organization, core development, exhibitions, advocates and more! Please come and ask any questions!
PostgreSQL Ask Me Anything
Various PostgreSQL community members attend SCaLE and are willing to meet with attendees and answer any questions. Many aspects of the community are covered: User groups, conference organization, core development, exhibitions, advocates and more! Please come and ask any questions!
PostgreSQL Ask Me Anything
Ask anything about the PostgreSQL Community. Technical, social or otherwise! A number of folks involved in the PostgreSQL community regularly attend SCaLE and make themselves available for questions.
PostgreSQL Ask Me Anything
Ask anything about the PostgreSQL Community. A number of folks involved in the PostgreSQL community regularly attend SCaLE and make themselves available for questions.
An Adventure in Data Modeling
This is a tale about one company's experience with a database schema design refactor to use the Entity-Attribute-Value (EAV) data model on its members. I will describe the original data model and why there was a need to move to a new data model. There was some stumbling along the way but company recovered and succeeded in implementing the EAV data model. But some lingering questions remain...
Coming attractions in the next major PostgreSQL release
The next major release of PostgreSQL, version 15, is expected to be released early in the fall. We will highlight the expected new features, improvements and other newsworthy topics.
PostgreSQL Ask Me Anything
A panel of PostgreSQL community members is here to answer any questions about any aspect of the project.
PostgreSQL Stored Procedures
Stored procedures have arrived with PostgreSQL 11. Come see what has been implemented, and how procedures differ from usr-defined functions. We will discuss some use cases for procedures such as migrating from other database management systems and manipulating data. There will be more features coming in future releases of PostgreSQL and we will cover some proposed enhancement to what a procedure can do.
Logical Replication in PostgreSQL
In this talk I will describe the current state of the pglogical project. I will cover use-cases that work well already, what the limitations are, future roadmap and also the state of integration of logical replication into PostgreSQL itself.
PostgreSQL Performance Presentation, 9.6devel Edition
We will present the latest test results comparing where we are with
9.6devel to the 9.5 branch. Additionally, there will also be data
to illustrate the gaps that Postgres may attempt to close between other open source column store database solution using DBT-3 (a synthetic ad-hoc decision support workload).
PostgreSQL Performance Presentation (9.5devel edition)
This presentation will review the performance changes of a some of the patches committed or pending for the PostgreSQL 9.5 development cycle.
