Jim Mlodgenski @@jim_mlodgenski
Principle Database Engineer at Amazon Web Services
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.
- 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 ...
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 Opspresented 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 Migrationspresented 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 SQLpresented 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 AdministrationPL/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 Developmentpresented 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 Daypresented 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 Devpresented 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.
PostgreSQLpresented 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:
presented by Jim Mlodgenski and Joshua D. Drake
Welcome to PGConf US Local: Seattle!
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:
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 Trainingpresented by Jim Mlodgenski
OpenSCG Keynote
Tue 5 2017Get 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 Developmentpresented 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 Postgrespresented 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 PostgresPostgres: 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