Online / 5 & 6 February 2022

visit

PostgreSQL devroom


09 10 11 12 13 14 15 16 17
Sunday Solving the knapsack problem with recursive queries and PostgreSQL JSON in PostgreSQL - Learning with a case study How to create (lots!) of sample time-series data with PostgreSQL generate_series() Future Postgres Challenges PostgreSQL Distributed & Secure Database Ecosystem Building
This session will focus on introducing how to empower PostgreSQL thanks to the ecosystem provided by Apache ShardingSphere - an open source distributed database, plus an ecosystem users and developers need for their database to provide a customized and cloud-native experience.
Automatically refresh materialized views in PostgreSQL
Tactics to make refreshing a painless process
Working effectively with (-support-) the community
This talk is for those who are new to PostgreSQL or those who just started, or all the others that want to hear a personal story: When I started with PostgreSQL around 10 years ago, I came with an Oracle background. It took me quite some time to understand how the PostgreSQL project is organized, how the community is working and how to deal with issues I've faced when I needed support. This is not a technical talk at all, but it should save you quite some time in your journey with PostgreSQL.
Exploring Linux Memory Usage and IO Performance for Cloud Native Databases Slow things down to make them go faster Lesser Known PostgreSQL Features
Features you already have but may not know about!

Read the Call for Papers at https://www.postgresql.org/message-id/163900296066.695.12240662022374343606%40wrigleys.postgresql.org.

PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 30 years of active development on the core platform.

PostgreSQL has earned a strong reputation for its proven architecture, reliability, data integrity, robust feature set, extensibility, and the dedication of the open source community behind the software to consistently deliver performant and innovative solutions. PostgreSQL runs on all major operating systems, has been ACID-compliant since 2001, and has powerful add-ons such as the popular PostGIS geospatial database extender. It is no surprise that PostgreSQL has become the open source relational database of choice for many people and organisations.

Getting started with using PostgreSQL has never been easier - pick a project you want to build, and let PostgreSQL safely and robustly store your data.

Event Speakers Start End

Sunday

  Solving the knapsack problem with recursive queries and PostgreSQL Francesco Tisiot 10:00 11:00
  JSON in PostgreSQL - Learning with a case study Boriss Mejias 11:00 12:00
  How to create (lots!) of sample time-series data with PostgreSQL generate_series() Ryan Booz 12:00 12:30
  Future Postgres Challenges Bruce Momjian 12:30 13:00
  PostgreSQL Distributed & Secure Database Ecosystem Building
This session will focus on introducing how to empower PostgreSQL thanks to the ecosystem provided by Apache ShardingSphere - an open source distributed database, plus an ecosystem users and developers need for their database to provide a customized and cloud-native experience.
Juan Pan 13:00 13:30
  Automatically refresh materialized views in PostgreSQL
Tactics to make refreshing a painless process
Attila Tóth 13:30 14:00
  Working effectively with (-support-) the community
This talk is for those who are new to PostgreSQL or those who just started, or all the others that want to hear a personal story: When I started with PostgreSQL around 10 years ago, I came with an Oracle background. It took me quite some time to understand how the PostgreSQL project is organized, how the community is working and how to deal with issues I've faced when I needed support. This is not a technical talk at all, but it should save you quite some time in your journey with PostgreSQL.
Daniel Westermann 14:00 15:00
  Exploring Linux Memory Usage and IO Performance for Cloud Native Databases Frits Hoogland 15:00 16:00
  Slow things down to make them go faster Jimmy Angelakos 16:00 17:00
  Lesser Known PostgreSQL Features
Features you already have but may not know about!
Haki Benita 17:00 18:00