Data Conference Databasea Query.Farm index
Speakers

Malcolm McLean

Employers on the program

  1. 2019–2025Evermed7 talks
Events5
Conferences2
Talks7
Years active2019–2025
Miles between events30,5815 in-person events · 3 countries

Appearances by year

201920202021202220232024202520262027
  • Postgres Conference (PostgresConf)
  • PG Down Under

Talks

DateEventConferenceRoleTitleLinks
Oct 17, 2025PG Down Under 2025PG Down UnderspeakerFrom smallint to bigint and char to varchar, it's time to demystify the data types
as Evermed
PostgreSQL has dozens of different data types. Some work better than others if different stations, but which do you choose for each situation? varchar or text?…Show less

PostgreSQL has dozens of different data types. Some work better than others if different stations, but which do you choose for each situation? varchar or text? int or bigint? Do you ever use money?

Slides
Mar 18, 2025Postgres Conference 2025Postgres Conference (PostgresConf)speakerFrom smallint to bigint and char to varchar, it's time to demystify the data types
as Evermed

PostgreSQL has dozens of different data types. Some work better than others if different stations, but which do you choose for each situation?

Mar 18, 2025Postgres Conference 2025Postgres Conference (PostgresConf)speakerPerformance tuning PostgreSQL
as Evermed
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…Show less

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.

Oct 8, 2019PostgresConf South Africa 2019Postgres Conference (PostgresConf)speakerEffectively securing your PostgreSQL database
as Evermed
Securing access to your database and data seems obvious, but are you doing enough? The default settings within PostgreSQL and even the default firewall…Show less

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.

Sep 18, 2019Postgres Conference Silicon Valley 2019Postgres Conference (PostgresConf)speakerEffectively securing your PostgreSQL database
as Evermed
Securing access to your database and data seems obvious, but are you doing enough? The default settings within PostgreSQL and even the default firewall…Show less

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.

Sep 18, 2019Postgres Conference Silicon Valley 2019Postgres Conference (PostgresConf)speakerPostgresql performance tuning - a crash course
as Evermed
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…Show less

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.

Mar 18, 2019Postgres Conference 2019 (PostgresConf US 2019)Postgres Conference (PostgresConf)speakerPerformance tuning PostgreSQL
as Evermed
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…Show less

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.

Frequent co-speakers

SpeakerShared eventsShared talksLast together
Lloyd Albin5—2025
Bennie Swart3—2025
Jim Mlodgenski3—2025
Hans-Jürgen Schönig3—2019
Abbas Butt2—2025
Amanda Nystrom2—2025
Dr. Ibrar Ahmed2—2025
Joshua D. Drake2—2025
Peter Zaitsev2—2025
Alvaro Hernandez2—2019
Andrew Dunstan2—2019
Avinash Vallarapu2—2019
dharshan rangegowda2—2019
Jacques Combrink2—2019
Jeremy Schneider2—2019

Speakers with the same name are merged into one entry, so this page may combine more than one person. Affiliations are shown as each conference listed them.