Malcolm McLean
Senior Software Engineer at Evermed
About
Malcolm is a Software Engineer, PostgreSQL DBA, Linux admin, tinkerer and a bit of a pedantic perfectionist, having over 19 years of experience with PostgreSQL and somewhat more than that with Linux and development.
Effectively securing your PostgreSQL database
Are you doing enough to secure your database and access to your data?
presented by Malcolm McLean
Securing access to your database and data seems obvious, but are you doing enough? The default settings within PostgreSQL and even the default firewall configuration on stock Linux installs are a far cry from being secure.
Even if you're not handling or storing credit card information, PCI-DSS defines many things to do in order to secure access to a database and operating system, which can b...
more Tue 8 2019 Ops and Administration
Postgresql performance tuning - a crash course
Tuning PostgreSQL isn't as hard as you think
presented by Malcolm McLean
Out of the box PostgreSQL comes with very conservative performance settings. In this 3-hour workshop, we'll look at more useful options that relate to performance and how to set them for your environment, as well as query optimization, statistics, operating system parameters and server resources.
There is no one-size-fits-all approach, but through this workshop, you'll get the fundamentals o...
more Wed 18 2019 Ops and Administration
Effectively securing your PostgreSQL database
Are you doing enough to secure your database and access to your data?
presented by Malcolm McLean
Securing access to your database and data seems obvious, but are you doing enough? The default settings within PostgreSQL and even the default firewall configuration on stock Linux installs are a far cry from being secure.
Even if you're not handling or storing credit card information, PCI-DSS defines many things to do in order to secure access to a database and operating system, which can b...
more Fri 20 2019 Ops and Administration
Performance tuning PostgreSQL
Tuning PostgreSQL isn't as hard as you think
presented by Malcolm McLean
Presented as full-day training
Out of the box PostgreSQL comes with very conservative performance settings. In this workshop, we'll look at many of the options that relate to performance and how to set them for your environment, as well as query optimization, statistics, operating system parameters and server resources.
There is no one-size-fits-all approach, but through this workshop, ...
more Mon 18 2019 Ops and Administration
Opening
presented by Malcolm McLean and Kobus Wolvaardt
Tue 9 2018
Performance tuning PostgreSQL
Tuning PostgreSQL isn't hard
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.
Wed 10 2018 Operations and Administration
A talk about indexes
Creating and maintaning indexes in PostgreSQL
presented by Malcolm McLean
video
This will be an introductory talk about indexes within PostgreSQL
Tue 9 2018 Operations and Administration
PostgreSQL in a geographically distributed realtime transactional system
Selectively replicating data across geographically distributed servers
presented by Malcolm McLean
How and why we utilise PostgreSQL, our specific requirements for replication, how we handle it, what alternatives we looked at and what we are investigating for the future.
Our system is a geographically distributed system across multiple countries where data needs to be selectively replicated between each set of servers based on that country's legislation and failover requirements. This pos...
more Thu 19 2018 Use Cases
Panel discussion
presented by Margrit Drescher, Malcolm McLean, Martin Slabber, and Kobus Wolvaardt
Discussion on Postgres usage by the participants as well as the South African postgres landscape.
Postgres
Utilising PostgreSQL in a realtime transactional system
Replicating data to a geographically distributed system
presented by Malcolm McLean
How and why we utilise PostgreSQL, our specific requirements for replication, how we handle it, what alternatives we looked at and what we are investigating for the future.
We will also look at a few simple, yet interesting things we do within the database.
Postgres
Securing your PostgreSQL database
Are you doing enough to secure your database and access to your data?
presented by Malcolm McLean
Securing access to your database and data seems obvious, but are you doing enough? The default settings within PostgreSQL and even the default firewall configuration on stock Linux installs are a far cry from being secure.
Even if you're not handling or storing credit card information, PCI-DSS defines many things to do in order to secure access to a database and operating system, which can...
more Postgres