South Africa 2019
PostgresConf South Africa 2019
The third annual South African PostgresConf takes place in Johannesburg on 8 & 9 October 2019, with attendees representing a diverse class of professionals and companies from around the country and across the continent. This is an excellent opportunity for the database administration and developer community who use PostgreSQL to get to know each other, exchange ideas and learn about the current features and upcoming trends within PostgreSQL.
Open Source Week
Open Source Week brings 3 conferences together in the same week, with PostgresConf South Africa 2019 taking place the day after LinuxConf [ZA] 2019 and before PyConZA 2019, the Python programming conference and a shared workshop/tutorial day on the Wednesday, with all three conferences hosted at the same venue.
If you would like to be kept up to date on current and future conferences and events, consider [subscribing to our newsletter] http://eepurl.com/dD-gKD). Volumes are low, only conference related, and you're welcome to unsubscribe any time.
If you have any questions about the conference, please send us an email to email@example.com.
The registration period ends in
Some of our speakers
Kartoza is a South African company with a global footprint. We specialise in geospatial solutions with FOSS, which means we use PostGIS a lot. We also present courses on PostGIS. This workshop is a condensed version of what we normally do in two or three days. You will get hands-on experience with loading spatial data, understanding geometries and using spatial data in analysis. In the process you will learn all about spatial SQL and also how to use a desktop GIS (QGIS) to interact with the...
Your database is performing badly but you got no idea why. Fortunately PostgreSQL has all the means to figure out what is really going on inside your database. You just have to find the right modules and use the right tools and understand what PostgreSQL is really trying to tell you. This talk will show you how to track down slow queries using pgstatstatement, work with "explain analyze" and fix bad performance using simple query rewrites.
I was recently asked by another PostgreSQL DBA about what could be causing queries to run slow while their application is running but then runs fast again after the application is stopped. While I have given several presentations on this subject, each one has been on a specific cause and not talking about all of them together. I decided I would compile them into a single tuning and monitoring presentation. These slow queries are reported to me by my developers when they start taking...
In an automated testing environment it is often a requirement to create a clean database for each group of tests, but creating and initializing new databases can be slow and resource intensive. In this talk we will look at a collection of tips and tricks to optimize the setup and teardown of new databases in an effort to significantly reduce the overall execution time of tests.
The amaGama (https://amagama.translatehouse.org/) project implements a FOSS translation memory web service built with Python on top of PostgreSQL. I recently worked on improving its performance, and would like to report on what I did and how I did it. The presentation will cover how an understanding of the problem domain, usage patterns and algorithms involved allowed for a big performance improvement despite some (arguable) shortcomings of PostgreSQL. A translation memory contains texts...
has the most awesome program ever!
See rock-star speakers cover the topics of
Operations and Administration
DBeaver by Nico Schlebusch
Finding and fixing slow queries by Hans-Jürgen Schönig
AutoVacuum - Tuning and Monitoring by Lloyd Albin
Postgres Extensions by Andries Vorster
PostgreSQL performance in 5 minutes by Hans-Jürgen Schönig
Effectively securing your PostgreSQL database by Malcolm McLean
PostgreSQL/PostGIS devops with Docker and Rancher by Gavin Fleming
Hacking with Postgres 11 - pg_threads by Piotr Jarmuż
PL/pgSQL Control Structures by Andreas Nel
From data model to hosted OpenAPI Specification (OAS) by Karel van der Walt
What's all this fuss about Common Table Expressions (CTE's) anyway? by Jacques Combrink
Triggers - Friends To Handle With Care by Charles Clavadetscher
Designing for Accessibility by Rory Preddy
GPU acceleration - An introduction by Willem Booysen
Working with spatial data in PostGIS by Gavin Fleming
Temporal Journey by Andrew Turpin
Event Stores and Postgres by Chris A. Pieterse
Is JSONB a Silver Bullet by Angus Dippenaar