About

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.


    Jim Mlodgenski Purpose Built Data Types

    presented by Jim Mlodgenski

    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...

    more

    Fri 20 2020 Dev and Ops
    Jim Mlodgenski Top 10 Mistakes When Migrating From Oracle to PostgreSQL

    presented by Jim Mlodgenski

    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.

    Thu 19 2020 Migrations
    Jim Mlodgenski An Introduction to Amazon Aurora

    presented by Jim Mlodgenski

    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...

    more

    Fri 20 2019 Distributed SQL
    Jim Mlodgenski PostgreSQL Managed Services at Amazon RDS: Best Practices

    presented by Jim Mlodgenski

    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...

    more

    Fri 20 2019 Ops and Administration
    Jim Mlodgenski Beginner's Guide to PostgreSQL Development
    PL/pgSQL Edition

    presented by Jim Mlodgenski

    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...

    more

    Tue 19 2019 Development
    Jim Mlodgenski Deep Dive on Amazon Aurora with PostgreSQL Compatibility

    presented by Jim Mlodgenski

    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...

    more

    Mon 18 2019 AWS Migration Day
    Jim Mlodgenski Top 10 Mistakes When Migrating From Oracle to PostgreSQL

    presented by Jim Mlodgenski

    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.

    Tue 16 2018 Dev
    Jim Mlodgenski Top 10 Mistakes When Migrating From Oracle to PostgreSQL

    presented by Jim Mlodgenski

    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.

    PostgreSQL
    Jim Mlodgenski Introduction to JavaScript Stored Procedures

    presented by Jim Mlodgenski

    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:

    • How to create a PL/V8 function
    • Interacting with database objects
    • Returning resu...
    more

    Postgres
    Joshua D. Drake Jim Mlodgenski Launch

    presented by Jim Mlodgenski and Joshua D. Drake

    Welcome to PGConf US Local: Seattle!

    Jim Mlodgenski Introduction to JavaScript Stored Procedures

    presented by Jim Mlodgenski

    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:

    • How to create a PL/V8 function
    • Interacting with database objects
    • Returning results ...
    more

    Tue 14 2017 dev
    Jim Mlodgenski PostgreSQL Administration

    presented by Jim Mlodgenski

    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.

    Mon 4 2017 Training
    Jim Mlodgenski OpenSCG Keynote

    presented by Jim Mlodgenski

    OpenSCG Keynote

    Tue 5 2017
    Jim Mlodgenski Migrating to PostgreSQL
    Get off your expensive proprietary database onto the most advanced open source database

    presented by Jim Mlodgenski

    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 ...

    more

    Development
    Jim Mlodgenski Strategic Autovacuum

    presented by Jim Mlodgenski


    video

    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_...

    more

    Postgres
    Jim Mlodgenski Introduction to PostgreSQL Performance Tuning

    presented by Jim Mlodgenski

    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...

    more

    Postgres
    Jim Mlodgenski Keynote
    Postgres: The Evolution of the community

    presented by Jim Mlodgenski

    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!

    Postgres