Joshua D. Drake @ChronicallyJD

Founder at Command Prompt, Inc.

About

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.

Joshua D. Drake has presented the following presentations

PostgresWorld Presents: A Live Digital Privacy Event with EFF, Sponsored by Command Prompt and The More than a Refresh Podcast at Postgres World Webinars 2023

presented by Joshua D. Drake
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...
more
Wed 20 2023 Dev
PostgreSQL v15 at PostgresWorld Webinars 2022
Overview and Features
presented by Joshua D. Drake
Join us for a live presentation (online) on an overview of the upcoming PostgreSQL v15 release!
Ops
Insights into Postgres, a journey since 1997 at Postgres Conference 2020


presented by Joshua D. Drake

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 at Postgres Webinar Series
Increasing performance and reducing complexity of migrations
presented by Joshua D. Drake and Erez Alsheich

video
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...
more
Thu 7 2020 Migrations
Postgresql V12: Features and Migration Considerations at Mini NYC 2019

presented by Joshua D. Drake
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.
Thu 24 2019
Silicon Valley Postgres Meetup at Silicon Valley 2019

presented by PostgresConf Organizers and Joshua D. Drake
• Postgres V12: Features and Migration Considerations

• What's New in YugaByte DB 2.0: PostgreSQL Compatibility on Geo-Distributed Storage Architecture and more!
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...
more
Wed 18 2019 Ops and Administration
PostgreSQL V12: Features and migration considerations at Silicon Valley 2019

presented by Joshua D. Drake
Learn all about the exciting upcoming release of PostgreSQL v12 including new features and migration considerations!
Thu 19 2019 Ops and Administration
Postgres: The World's Database at Beijing 2019
Postgres: The World's Database
presented by Joshua D. Drake
The PostgreSQL industry, ecosystem etc
Thu 4 2019 Main
Postgres Performance and Maintenance at PGConf Local: Philly 2017 [PgConf.US]
Tuning and configuration for optimum performance
presented by Joshua D. Drake
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...
more
PostgreSQL
Postgres v10: An Amplified version of PostgreSQL at PgConf US Local: Ohio [PgConf.US]

presented by Joshua D. Drake
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.
Sat 30 2017 Postgres
POSTGRESQL V10: AN AMPLIFIED VERSION OF POSTGRES at PGConf Local: Seattle [PgConf.US]

presented by Joshua D. Drake
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.
ops
Launch at PGConf Local: Seattle [PgConf.US]


presented by Jim Mlodgenski and Joshua D. Drake

Welcome to PGConf US Local: Seattle!

Postgres Performance and Maintenance at PGConf Local: Seattle [PgConf.US]

presented by Joshua D. Drake
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...
more
Trainings
Postgres Performance and Maintenance at PGConf Local: Austin [PgConf.US]

presented by Joshua D. Drake
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...
more
Training
The Power of Postgres Replication at PGConf Local: Austin [PgConf.US]

presented by Joshua D. Drake
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.
Ops
Pacific Crest Trail: The postgresql.conf from A-Z at PGConf US 2017 [PgConf.US]
The in and out of the postgresql.conf file.
presented by Joshua D. Drake
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...
more
Training
Softlayer vs RDS/AWS: A price to performance perspective at PGConf US 2017 [PgConf.US]
Where is the line in the sand against dollars to performance sense.
presented by Joshua D. Drake

video
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 ...
more
Wed 29 2017 Use Cases
Kicking the Donkey of PostgreSQL Replication at PGConf US 2016 [PgConf.US]

presented by Joshua D. Drake
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...
more
Operations
Elevating Your Confidence with PostgreSQL's Restoration Capabilities! at PGConf US 2016 [PgConf.US]

presented by Joshua D. Drake
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...
more
Operations
Webscale's dead; long live PostgreSQL! at PGConf US 2015 [PgConf.US]

presented by Joshua D. Drake
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...
more
Strategy
Kicking the Donkey of PostgreSQL Replication at PGConf NYC 2014 [PgConf.US]

presented by Joshua D. Drake
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...
more
Admin
The postgresql.conf from A-Z: Includes Postgres Performance and Maintenance at PostgresConf US 2018

presented by Joshua D. Drake
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...
more
Operations and Administration