Jim Mlodgenski
Principle Database Engineer at Amazon Web Services
Jim has more than 20 years of experience developing data intensive applications and infrastructure. Prior to joining AWS, Jim was CTO at OpenSCG and CEO at StormDB, a Postgres-XC scalable public cloud solution. While at StormDB, Jim envisioned the offering and was responsible for all product development. Prior to StormDB, Jim was chief architect at EnterpriseDB, leading the firm’s technology direction, including its early cloud offerings and other product lines. Jim also very active in the PostgreSQL community, co-founding both the New York and Philadelphia PostgreSQL Meetup groups, co-organizing the largest PostgreSQL conferences, and serving on the Board of the PostgreSQL Foundation. Jim also speaks regularly at PostgreSQL and other open sources conferences.
Upcoming presentations
No upcoming presentations...
Past presentations
- How to create a PL/V8 function
- Interacting with database objects
- Returning resu...
- How to create a PL/V8 function
- Interacting with database objects
- Returning results ...
PostgreSQL has a rich history at Amazon from wide spread usage across the company to a number AWS offerings. In this session, we will discuss how Amazon started its journey into PostgreSQL including the mass migration off of Oracle and the origins of Amazon RDS for PostgreSQL. We will then talk about how PostgreSQL is used today throughout Amazon and the current AWS offerings including Amazon A...
Mar 19 2025
Want to build a generative AI application with PostgreSQL but unsure how to get started? In this talk, we will learn the essential tools for creating your own generative AI applications, including LangChain and pgvector. We will walk through some code so you can see firsthand what's required to connect these tools together. We'll do this by using a Retrieval Augmented Generation (RAG) applicati...
Mar 19 2025
When designing applications, the database schema is usually an afterthought. When the time comes to finally create the tables, developers normally just use a few base data types, like integers, varchars and timestamps, but PostgreSQL can do more. PostgreSQL's architecture allows for easy extension of data types. In this talk, we will explore some of PostgreSQL's purpose built data types that ca...
Nov 20 2020
As more and more people are moving to PostgreSQL from Oracle, a pattern of mistakes is emerging. They can be caused by the tools being used or just by not understanding how PostgreSQL is different than Oracle. In this talk, we will discuss the top mistakes people generally make when moving to PostgreSQL from Oracle and what the correct course of action.
Nov 19 2020
Amazon Aurora is a relational database service for OLTP workloads offered as part of Amazon Web Services (AWS). In this talk, we describe how Aurora brings a novel architecture to the relational database by pushing redo processing to a multi-tenant scale-out storage service, purpose-built for Aurora. We describe how doing so not only reduces network traffic, but also allows for fast crash recov...
Sep 20 2019
PostgreSQL databases are supported on Amazon Relational Database Service (RDS) since 2013. Amazon RDS provides an ideal platform to run your PostgreSQL databases - be it a mission critical OLTP or a data warehouse or an analytics database or databases for test & development. This session provides best practices to deploy your PostgreSQL databases, perform upgrades, choose data protection option...
Sep 20 2019
Beginner's Guide to PostgreSQL Development
PL/pgSQL Edition
When developing against a PostgreSQL database, many times you will use SQL from your applications, but sometimes you need more. You might need to run some of your logic on the database server for performance or you may want to just create some server side functions to simplify your application development. There are an infinite number of reasons why you would want to write some code that runs o...
Mar 19 2019
Amazon Aurora with PostgreSQL compatibility is a relational database service that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. We review the functionality in order to understand the architectural differences that contribute to improved scalability, availability, and durability. We also dive deep into th...
Mar 18 2019
As more and more people are moving to PostgreSQL from Oracle, a pattern of mistakes is emerging. They can be caused by the tools being used or just not understanding how PostgreSQL is different than Oracle. In this talk we will discuss the top mistakes people generally make when moving to PostgreSQL from Oracle and what the correct course of action.
Oct 16 2018
As more and more people are moving to PostgreSQL from Oracle, a pattern of mistakes is emerging. They can be caused by the tools being used or just not understanding how PostgreSQL is different than Oracle. In this talk we will discuss the top mistakes people generally make when moving to PostgreSQL from Oracle and what the correct course of action.
One of the great features of PostgreSQL is its pluggable language handler allowing many different types of stored procedure languages including JavaScript aka PL/V8. This allows web developers to leverage their existing coding skills when writing database sever-side code. In this talk we will discuss:
Welcome to PGConf US Local: Seattle!
One of the great features of PostgreSQL is its pluggable language handler allowing many different types of stored procedure languages including JavaScript aka PL/V8. This allows web developers to leverage their existing coding skills when writing database sever-side code. In this talk we will discuss:
Nov 14 2017
This training workshop covers all aspects of PostgreSQL administration, including installation, security, file structure, configuration, reporting, backup, daily maintenance, monitoring activity, disk space computations, and disaster recovery. It shows how to control host connectivity, configure the server, find the query being run by each session, and find the disk space used by each database.
Dec 4 2017
OpenSCG Keynote
Dec 5 2017
Migrating to PostgreSQL
Get off your expensive proprietary database onto the most advanced open source database
Whether it is for cost reasons or simply convenience, many people are migrating their mission-critical databases to PostgreSQL. Most of the time, people are moving from Oracle, but many are moving from Sybase, SQL Server, MySQL or even MongoDB. Depending on your application making the switch can be extremely simple or impossible. This tutorial will teach how to identify the differences and how ...
We have all heard about this dreaded thing in PostgreSQL called vacuum, but what is it really and why do we need to do it. In this talk, we will talk about why PostgreSQL needs to vacuum tables and how to manage it. It will focus on configuring autovacuum properly for your application. In the end, you will understand how and why to set things like autovacuum_vacuum_threshold and autovacuum_max_...
Out of the box, PostgreSQL is configured to run on very small systems like a Raspberry Pi, but people do not run large scale enterprise applications on a Raspberry Pi. There are many knobs and switches to tune PostgreSQL for your workload, but which ones make a difference. In this talk, we will discuss those knobs and switches on the operating system and the postgresql.conf file that affects pe...
Keynote
Postgres: The Evolution of the community
In this presentation we will discuss Jim's experiences with the Postgres community and how it has grown beyond ideological boundaries to incorporate all manners of community, technology and business. Join CTO of OpenSCG Jim Mlodgenski in a grand exposition of the evolution of the Postgres community. Where Postgres started, where Postgres is and where Postgres is going!