Mark Wong

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!

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.

Ask anything about the PostgreSQL Community. A number of folks involved in the PostgreSQL community regularly attend SCaLE and make themselves available for questions.

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...

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.

A panel of PostgreSQL community members is here to answer any questions about any aspect of the project.

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.

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.

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).

This presentation will review the performance changes of a some of the patches committed or pending for the PostgreSQL 9.5 development cycle.