Opening & Welcome

presented by PostgresConf South Africa Organisers

09:00 - 09:10 Online

Riding the second wave
Open Source for relational databases

presented by Jan Karremans

Open Source software solutions are nothing new. Free – as in freedom – software was introduced nearly immediately after software and hardware got separated, in the ’50 of the last century.

We see a surge in the adoption of Open Source, especially as more complex systems get introduced as open solutions. This presentation discusses the various “waves” we can observe in Open Source solutions a...

more

09:20 - 10:00 Online Case Studies

Reducing Costs and Improving Performance With Data Modeling in Postgres
Understanding how PostgreSQL organizes the data internally can save costs!

presented by Charly Batista

During this talk we will explain how PostgreSQL organizes the data internally, how the Free Space Map (FSM) works and how we can reorganize the data model to take advantage of data alignment inside blocks reducing the size of the data in disk and consequently in memory, which can save money and improve performance.

10:10 - 10:50 Online Ops & Administration

pg_timetable: PostgreSQL scheduling done right
Scheduling on steroids

presented by Hans-Jürgen Schönig

Many schedulers for PostgreSQL have come and gone. When pg_timetable was developed we tried to learn from past mistakes and build a scheduler that is powerful and which can last. It offers every feature needed in the real world and offers a new approach to scheduling in PostgreSQL. Let us dive in and find out what it can do to provide an even better user experience.

11:00 - 11:40 Online Development

Modularizing computation via Common Table Expressions (CTEs)
Functional-declarative vs. Imperative styles of computation

presented by Karel van der Walt

SQL allows for a terse expression of computation via the declarative style.

PostgreSQL lateral joins and set-returning functions remove the need for explicit iteration in computation.

SQL Common Table Expression (CTEs) - and some PostgreSQL-specific features - allow for new modes of modularisation of a computation.

This modularised computation still follows the economy ...

more

11:50 - 12:30 Online Development

Lunch break

presented by PostgresConf South Africa Organisers

Lunch time

12:30 - 13:30 Online

When it all GOes right
How to write cross-platform application for PostgreSQL

presented by Pavlo Golub

This talk covers how to use PostgreSQL together with the Golang (Go) programming language. I will describe what drivers and tools are available and which to use nowadays.

In this talk I will cover what design choices of Go can help you to build robust programs. But also, we will reveal some parts of the language and drivers that can cause obstacles and what routines to apply to avoid risk...

more

13:30 - 14:10 Online Development

Benefit of adopting Kubernetes for self-hosted PostgreSQL stack

presented by Rizky Maulana Nugraha

Benefit of adopting Kubernetes for self-hosted PostgreSQL stack

The talk aimed for any small/medium company where the sysadmin team manages multiple instances of PostgreSQL as part of their application. The focus is to help these companies decide if Kubernetes adoption is worth for them by highlighting the possible benefit and burden in adopting these technology.

As a background info, ...

more

14:20 - 15:00 Online Ops & Administration

Routing with PostGIS and OpenStreetMap

presented by Ryan Lambert

Show how to easily load and prepare OpenStreetMap roads for routing. Data prep includes access control and multiple routing methods (motor, cycle, foot). This process shows a variety of intro-PostGIS concepts and functions as part of a more advanced talk in disguise. Also covers new features in osm2pgsql, the main tool used to load OSM data into PostGIS.

Download and Links: [https://blog....

more

15:10 - 15:50 Online PostGIS

Closing

presented by PostgresConf South Africa Organisers

15:50 - 16:00 Online