South Africa 2018 Program

presented by PostgresConf South Africa Organisers

presented by Malcolm McLean and Kobus Wolvaardt

presented by Kobus Wolvaardt

Can you quickly find a one face in a million? How quickly can these queries be done?

presented by PostgresConf South Africa Organisers

Coffee time (or tea if you prefer that)

presented by Hendrik Visage

ZFS have been around for more than a decade, but only recently become a viable option on Linux. It's on-the-fly compression can help alleviate IO bottlenecks and save on diskspace used. The author will share about the compression, snapshot and recovery features that system administrators would love, but also needs to beware of the constraints and impacts of the options. The author will share s...

presented by David Wein

PostgreSQL 9.6 introduced wait events, and support was greatly enhanced in version 10. Simply put, wait events tell you why a query isn't making progress. This talk will cover how to monitor waits as well as the most common waits encountered and what they mean. Finally, we will introduce enhanced wait event monitoring available in Amazon's Aurora PostgreSQL.

presented by Johan Zietsman

Getting up to speed and becoming productive with a new tool can be daunting. Postgres is no different. When onboarding new team members it is a great help to have a solid set of resources to get them going quickly. This talk will give an overview of the Postgres resources available for this purpose.

presented by Nico Schlebusch

Enhance your psql client experience

Some tips and tricks to enhance the experience with the psql client in your daily tasks as a developer or dba.

presented by Mureithi Runji

This talk is meant to give an introduction to PostGIS and GIS related functions within the PostGIS extension. PostGIS shall be presented as a solution to contemporary industry challenges involving geo-referenced data.

presented by Johan Zietsman

Newcomers to Postgres and the open source world do not always know about the tools that are available to get a database up and running quickly and reliably. Powerful automation tools are available that increase productivity, transparency, and maintainability. Ansible is one of these.

The talk is targeted to Ansible novices, but who already have experience with Linux and Postgres. Ansible wil...

presented by Willem Booysen

Window Functions appear to be generally underutilised in the real world. Compared to CTE's and basic Select queries, one seldom sees Window Functions in SQL blogs, stackoverflow pages, forums, etc. (unless the article is dedicated to Window Functions). My opinion is that this is due to the syntax and different way of thinking about Window Functions compared to normal SQL syntax and use. Thi...

presented by PostgresConf South Africa Organisers

presented by George Nel

A talk about Constraints with examples.(slides will be expanded with examples)

presented by David Wein

PostgreSQL is a debt-based system that pays for fast writes on credit. It's up to vacuum to pay the bills before it's too late.

Vacuum remains one of the most challenging and mysterious aspects of PostgreSQL. Most users know the why of vacuum but are fuzzy on the how. This session will be a deep dive into the internals of vacuum, its algorithms, and includes a discussion of how ...

presented by Helge Reikeras

In this talk I'll discuss two frequently held misconceptions about data science (a) that data science requires data to be duplicated in a dedicated big data system like Hadoop, and (b) that you need a PhD degree in Computer Science or Mathematics to be a data scientist.

To this end I'll talk about how data science can be performed using existing database infrastructure, through using Postg...

presented by Malcolm McLean

This will be an introductory talk about indexes within PostgreSQL

presented by Terence Zekveld

Introduction to CTEs

presented by Bennie Swart

In this talk we examine the use cases of Row Level Security (RLS) which was introduced in PostgreSQL 9.5.

In traditional applications, it is very common to find a lot of access control code residing inside the application layer, where the application connects to the database with a single database user, but multiplexing multiple application users. The database user typically has more rights ...

presented by PostgresConf South Africa Organisers

Coffee time (or tea if you prefer that)

presented by Kobus Wolvaardt

How to setup streaming replication (using some docker fun doing it live).

presented by Donovan White

Take a look into how to deploy and maintain the leading OSS relational database platform, we will also dive into the latest feature enhancements such as Performance Insights to understand their workloads, identify bottlenecks, and detect changes in query performance, Advanced Threat Protection which makes it simple to address database threats without the need for a security expert or to manage ...

presented by Jacques Combrink

A thorough look into JSONB functions, operators and use cases.

Where and how to use the JSONB functions and operators effectively.

Differences between JSONB and JSON.

presented by Abhinav Singh

With licenses that could cost as much as a whole implementation it is great to know that there is an easy way to migrate your Oracle environments to PostgreSQL.

We will show you how to migrate to PostgreSQL using Database Schema conversion tool and Database Migration Service to have a near real-time DR solution or even a PostgreSQL slave for an Oracle database.

presented by Christo Goosen

Postgresql is loved for its performance, features and robustness. A database done right only works right when accessing it in a performant way. In large, distributed cloud systems postgresql can run like a cheetah, but trying to hold onto its tail is your hippo of a application.

Libraries like https://github.com/MagicStack/asyncpg allow connections with via highspeed event loops rather than ...

presented by Malcolm McLean and Kobus Wolvaardt

presented by PostgresConf South Africa Organisers

presented by Hendrik Visage

ZFS in practice for SysAdmin & DBA

presented by PostgresConf South Africa Organisers

presented by Malcolm McLean and Kobus Wolvaardt

Out of the box PostgreSQL comes with very conservative performance settings. In this talk, we'll look at some of the options that relate to performance and how to set them for your environment.