Kobus Wolvaardt
MD at Goodx / Quant Solutions
I like playing with technology and love running a medical software company in South Africa
Upcoming presentations
No upcoming presentations...
Past presentations
Postgres in Dockers on ZFS
How we manage a large amount of postgres DBs and clusters on ZFS spin disks in dockers.
Our journey from large 200 database clusters on mirrored SSDs to smaller 20 to 40 databases per cluster and 4 to 10 clusters per machine on spin disks using ZFS. How we manage replication, how we backup 2500 DBs (hint ZFS snapshots) and just some of the fun things we saw on our journey.
Apr 17 2024
Oct 9 2018
Face recognition and PostgreSQL
How to quickly find a face in a database with postgres, python and some deeplearning
Can you quickly find a one face in a million? How quickly can these queries be done?
How to setup streaming replication (using some docker fun doing it live).
Performance tuning PostgreSQL
Tuning PostgreSQL isn't hard
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.
Oct 10 2018
Coffee
Lunch
Moning Coffee
Coffee and biscuits
Coffee
Discussion on Postgres usage by the participants as well as the South African postgres landscape.
Registration
How we use postgresql in our medical and financial software
How we use postgresql in our medical and financial software
GoodX software uses PostgreSQL as a financial database backend as well as for storing patient clinical data. In addition to that we use GoodX in our medical aid transaction and workflow transaction server.
Some fun with JSONB and LISTEN/NOTIFY
How we use listen/notify through websockets to refresh JSON blobs from the DB with no polling involved.
Some fun with JSONB. How we use LISTEN NOTIFY and JSONB to do some fun stuff with our web frontend.
Quick run through of features.