Joshua D. Drake
Founder at Command Prompt, Inc.
Joshua (JD) Drake is the President and CTO of Command Prompt, Inc., the oldest Postgres Company. He is also the Founder and Co-Chair of Postgres Conference (PostgresConf), the largest non-profit Postgres Community and Ecosystem conference. The founder of United States PostgreSQL (PgUS) and a Director for PgCentral, Inc. He has been using, deploying and extending PostgreSQL and related technologies since 1997.
Upcoming presentations
No upcoming presentations...
Past presentations
- Are you a Boss or a Leader?
- Are you a resource or an asset?
Postgres V12: Features and Migration Considerations
What's New in YugaByte DB 2.0: PostgreSQL Compatibility on Geo-Distributed Storage Architecture and more!
What do you give up by making profit the goal instead of the reward. In this keynote we will explore the very real world implications that come about from forgetting our primary needs are intentional connection, good ethics and community.
Mar 19 2025
What’s the future of the internet? Will it survive the next marketing-generated hype cycle? Why is there an ethical dilemma linking the internet and the stock market? Is anyone really thinking about these issues?
Postgres World, in conjunction with Command Prompt Inc’s More than a Refresh podcast, i...
Sep 20 2023
PostgreSQL v15
Overview and Features
Join us for a live presentation (online) on an overview of the upcoming PostgreSQL v15 release!
Join JD on a mystical, fantastical and ethereal journey through the paradigm of white glove professional Postgres services since 1997.
How to Move Data from Oracle to Postgres in Near-Real Time
Increasing performance and reducing complexity of migrations
Replicating live data (thousands of events per second) from Oracle to Postgres doesn’t have to be difficult. But the latency and complexity of traditional solutions, such as ETL, legacy CDC and homegrown scripts, have proven to be costly and inefficient. When you are replicating live data from one data platform to another, the process should be simple, inexpensive and as near real time as poss...
With each major release PostgreSQL continues to cement itself as the platform of choice for enterprise after enterprise. Join us in exploring the latest release, it's features and some important migration considerations.
Oct 24 2019
Doors open at 6:00 PM, first presentation starts at 6:30PM.
After the meetup there will be networking opportunities in the Hotel bar.
You do not need a ticket to Postgres Conference to attend the meetup. Of course the confe...
Sep 18 2019
Learn all about the exciting upcoming release of PostgreSQL v12 including new features and migration considerations!
Sep 19 2019
Postgres: The World's Database
Postgres: The World's Database
The PostgreSQL industry, ecosystem etc
Jul 4 2019
Postgres Performance and Maintenance
Tuning and configuration for optimum performance
When you are optimizing PostgreSQL it is usually maintenance that goes by the wayside. How do we fix autovacuum? Where did all of this bloat come from? Why am I getting IO spikes? How do I get RDS to behave?! Why are commits so slow on replication? The answer to all of these questions is understanding the relationship between proper Postgres maintenance and performance. Join us for a 3 hour jau...
Let's talk about the amazing Postgres v10. In this presentation we will discuss all the major highlights of what is upcoming in the new release. We will cover everything from Replication, performance features to new noSQL functionality. Let's take a ride down this roller coaster and discover why Postgres v10 should be the center of your data universe.
Sep 30 2017
Let's talk about the amazing Postgres v10. In this presentation we will discuss all the major highlights of what is upcoming in the new release. We will cover everything from Replication, performance features to new noSQL functionality. Let's take a ride down this roller coaster and discover why Postgres v10 should be the center of your data universe.
Welcome to PGConf US Local: Seattle!
When you are optimizing PostgreSQL it is usually maintenance that goes by the wayside. How do we fix autovacuum? Where did all of this bloat come from? Why am I getting IO spikes? How do I get RDS to behave?! Why are commits so slow on replication? The answer to all of these questions is understanding the relationship between proper Postgres maintenance and performance. Join us for a 3 hour jau...
When you are optimizing PostgreSQL it is usually maintenance that goes by the wayside. How do we fix autovacuum? Where did all of this bloat come from? Why am I getting IO spikes? How do I get RDS to behave?! Why are commits so slow on replication? The answer to all of these questions is understanding the relationship between proper Postgres maintenance and performance. Join us for a 3 hour jau...
With PostgreSQL v10 a new replication engine has come to town. Let's explore Postgres Logical Replication, how to use it, optimize it and let it best fit in with your organization. We will also discuss its interactions with external tools as well as Binary Replication and features such as Hot Standby.
Pacific Crest Trail: The postgresql.conf from A-Z
The in and out of the postgresql.conf file.
Everybody uses it, almost nobody knows what each parameter means. Just like the Pacific Crest Trail, most people have heard of it but few people have taken the 3-4 months to seek inner peace and understanding by hiking this gorgeous section of the United States. Let's take a 3-4 hour hike and explore the postgresql.conf. We will cover the desert of memory settings, to the mountains of the backg...
Softlayer vs RDS/AWS: A price to performance perspective
Where is the line in the sand against dollars to performance sense.
It seems like everyone is talking about Amazon Web Services. I deployed! Don't get me wrong, Amazon offers a great service but what are you really getting for your money? This talk discusses the price to performance ratio between these two cloud offerings, when it makes sense to use each one and even a little bit of ideology of why you should or shouldn't. Let's talk shop with real numbers and ...
Fully updated from 2014, this talk takes into account all the goodies that are available for PostgreSQL replication including but not limited to: * Streaming Replication * Archiving Replication * Management of both types * Logical Replication (PgLogical) If you are new to PostgreSQL replication this talk will provide you with everything you need to know about 95% of PostgreSQL Replication techn...
This half day training is fresh from being sold out at PgConf.eu. Fully updated with a comprehensive look at Point in Time Recovery and ZFS snapshots we will focus purely on the backup and restore of your data with PostgreSQL. In this training you will learn the nuances of PostgreSQL's built in backup and restore capabilities as well as external abilities brought about by technologies such as s...
Those of us who know PostgreSQL know that we are royalty. Yes, yes, let's be humble. We are "a" royal. But we are royalty of AWESOME. Yes, our technology base is over 40 years ago but what a 40 years it has been! In this talk we will briefly discuss history but more importantly we will pointedly discuss why the fads you read in CTO magazine are not the fads of reality. I will show where the "al...
Have you ever wondered how to configure PostgreSQL Replication? Have you ever wondered how to configure PostgreSQL Log Shipping? Have you ever wondered: Which one is best for my application? Are you aware of the pitfalls of Replication? Where it breaks? When it will act in a way that is counter-intuitive? Do you know how to fix it? Do you know how to monitor it? If you have asked yourself any o...
This comprehensive training incorporates the always popular half day training: Postgres Performance and Maintenance. To round out the training we incorporate information on everything from provisioning, max_connections, adjusting the planner, managing bg_writer, logging, autovacuum and nuanced information such as the wal_writer, synchronous_commit and how shared_buffers work. There will be ampl...