Upcoming presentations
No upcoming presentations...
Past presentations
Fireside chat: Building Postgres w/Bruce Momjian & Greg Kemnitz
Building the original Postgres code-base at Berkeley
<placeholder> * The early Postgres years at Berkeley * Database design challenges * Database industry trends
Postgres has been a vibrant project for decades, and probably will be popular for decades to come. However, as with any complex endeavor, challenges are always lurking. This talk explores the many project, competitive, and technical challenges in the future that could derail its success. By exploring these challenges, we will be better able to avoid them.
Postgres has always had strong support for relational storage. However, there are many cases where relational storage is either inefficient or overly restrictive. This talk shows the many ways that Postgres has expanded to support non-relational storage, specifically the ability to store and index multiple values, even unrelated ones, in a single database field. Such storage allows for greater ...
This presentation explains how open source software can live for a very long time, and covers the differences between proprietary and open source software life cycles. It also covers the increased adoption of open source, and many of the ways that Postgres is innovating to continue to be relevant.
This presentation highlights the challenges of building and managing an open source team of volunteers. Topics include motivation, communication, and project management.
Developer Unconference
Developer Unconference
This is a developer unconference.
Hosted by Bruce Momjian
Do come if you have interesting Postgres feature ideas
This presentation explains how open source software can live for a very long time, and covers the differences between proprietary and open source software life cycles. It also covers the increased adoption of open source, and many of the ways that Postgres is innovating to continue to be relevant.
Artificial intelligence, machine learning, and deep learning are intertwined capabilities that attempt to solve problems that defy traditional computational solutions --- problems include fraud detection, voice recognition, and search result recommendations. While they defy simple computation, they are computationally expensive, involving computation of perhaps millions of probabilities and wei...
Containers and the cloud are all the rage as companies seek new efficiencies and flexibility. While they are very popular, database use of these facilities is still growing. This talk explores their benefit for database deployments.
Join PostgreSQL Core Member and Committer, Bruce Momjian in exploring the current community efforts to bring a new standard of data privacy to PostgreSQL users. In this presentation we will talk about the status of current efforts, the expectations for the upcoming release of PostgreSQL 13 and future plans. We will also touch briefly on current security trends and where PostgreSQL needs to expa...
Developers are often challenged to deliver results that are hard to implement using simple SQL queries. Fortunately, complex SQL capabilities exist in the SQL standard --- common table expressions and window functions.
SQL is a declarative language, meaning the user submits an SQL command and the database determines the optimal execution. Common Table Expressions (CTEs) allow queries to be...
PostgreSQL 10 is moving along its beta cycle with a likely release this fall. It has many new and exciting features like Logical Replication and Partitioning. This talk will discuss the many upcoming features in PostgreSQL 10.
In this course you will learn the essential details of PostgreSQL configuration, security, maintenance, monitoring, tuning, backups, recovery. The course is designed for people with experience in database administration but who are new to the Postgres platform.
After a fun day at PGConf Local: Philly, end the week with a little more PostgreSQL on your way home. If you are near Philadelphia and a PostgreSQL lover, Bruce Momjian has invited you to attend the 2017 Postgres Party at his home in Newtown Square:
When: Friday, July 14, 6:20pm
Where: Momjian Residence in Newtown Square, Pennsylvania (directions)...
PostgreSQL 10 is moving along its beta cycle with a likely release this fall. It has many new and exciting features like Logical Replication and Partitioning. This talk will discuss the many upcoming features in PostgreSQL 10.
Normal SQL queries return rows where each row is independent of the other returned rows. SQL window functions allow queries to return computed columns based on values in other rows in the result set. This presentation explains the many window function facilities and how they can be used to produce useful SQL query results.
Multi-Version Concurrency Control (MVCC) allows Postgres to offer high concurrency even during significant database read/write activity. MVCC specifically offers behavior where "readers never block writers, and writers never block readers". This talk explains how MVCC is implemented in Postgres and highlights optimizations which minimize the downsides of MVCC. This talk is for advanced users.
As new business requirements grow, solutions with open standards are growing as well to support developer needs. During this workshop, Bruce Momjian, Co-Founder of the PostgreSQL Global Development Group and Senior Database Architect at EnterpriseDB, will walk through the most important things developers need to know to stay ahead of digital transformation.
Learn about: - Data management s...
SQL is a declarative language, meaning the user submits an SQL command and the database determines the optimal execution. Common Table Expressions (CTEs) allow queries to be more imperative, allowing looping and processing hierarchical structures that are normally associated only with imperative languages. This talk will help developers use implement CTE queries in their applications and allow ...
Postgres has the unique ability to act as a powerful data aggregator in many data centers. This talk shows how Postgres's extensibility, access to foreign data sources, and ability handle NoSQL-like and data warehousing workloads gives it unmatched capabilities to function in this role.
Postgres 11 and Beyond
A panel on Postgres 11 features and future development
An interactive panel with Postgres hackers and developers, moderated by Bruce Momjian.
Normal SQL queries return rows where each row is independent of the other returned rows. SQL window functions allow queries to return computed columns based on values in other rows in the result set. This presentation explains the many window function facilities and how they can be used to produce useful SQL query results.
This presentation needs 65 minutes so has to be before lunch, a brea...
This talk is designed for PostgreSQL administrators. It covers all aspects of PostgreSQL administration, including installation, security, file structure, configuration, reporting, backup, daily maintenance, monitoring activity, disk space computations, and disaster recovery. It shows how to control host connectivity, configure the server, find the query being run by each session, and find th...