Joshua D. Drake Blog Posts

PGConf Local: Seattle 2017 registration open and schedule published

The first ever PGConf US Local: Seattle event is happening in partnership with SEAPUG on August 11th and 12th at the Sheraton Downtown Seattle! On August 11th we have four training options available:
  1. Mastering PostgreSQL Administration by Bruce Momjian
  2. Migrating from Oracle to PostgreSQL by Jim Mlodgenski
  3. Postgres Performance and Maintenance by Joshua (JD) Drake
  4. Database Automation by Robert Bernier 

Tickets are now available!


On August 12th we have 14 break-out sessions between the Development and Operations tracks. A sample of our break-out sessions is available below but please check the full schedule for all of the fantastic content!
We would not be able to produce PGConf Local: Seattle 2017 without the generous support from our sponsors:
    Sponsorship opportunities for the conference are still available. If you use Postgres, support Postgres, or if you are looking to recruit a local Postgres expert, this is a great opportunity. Become a part of our dynamic and growing ecosystem! The prospectus is available at:
    Joshua D. Drake     July 11, 2017

    PGConf Local: Philly 2017 registration open and schedule published

    The third PGConf US event of the year is happening July 13 - 14th! Tickets are now available!

    This year the event is at Huntsman Hall located at The Wharton School. There will be two days of awesome Postgres content. On July 13th we are pleased to offer two great training sessions by two of the most veteran members of the PostgreSQL community, Bruce Momjian and Joshua Drake. Between them they have well over 40 years of hands-on experience with PostgreSQL. 

    On July 14th we have eight first-rate sessions covering everything from Postgres performance to development. Check out the full schedule here:
    Sponsorship opportunities for the conference are still available. If you use Postgres, support Postgres, or if you are looking to recruit a local Postgres expert, this is a great opportunity. Become a part of our dynamic and growing ecosystem! The prospectus is available at:

    We would not be able to produce PGConf Local: Philly 2017 without the generous support from our sponsors:

    For more information about PGConf US please visit: PGConf US


    PGConf US: People, Postgres, Data



    Joshua D. Drake     June 20, 2017

    Cancelled: Postgres Conference 2020: March 23rd - 27th

    People, Postgres, Data,

    Due to the health risks and travel restrictions created by the Coronavirus we unfortunately have to cancel Postgres Conference 2020 which was to be held at the Marriott Marquis on March 23rd, 2020 thru March 27th, 2020.

    We want to thank all of our attendees, partners and volunteers for all the hard work we all put in to try and pull this event off. Sadly, the stars were not aligned this year. We now focus our efforts on Postgres Conference Silicon Valley 2020 and our Digital Events. 

    Thank you all for your patience and support,

    Postgres Conference Chairs

    Joshua D. Drake     March 12, 2020

    CFP for PostgresConf Silicon Valley closes August 15th

    You will want to mark your calendars folks on August 15th the Call for papers for PostgresConf Silicon Valley will close. That is just two weeks away!

    So let's point your Firefox, Google Chrome, or Safari app to this link right here and get your presentation submitted.

    This is the inaugural Silicon Valley conference and from the current submitted papers it is shaping up to be a fantastic event. We can't wait to see everyone and continue our mission of:




    Joshua D. Drake     July 31, 2018

    PGConf US Local: Ohio CFP Open and Training announced

    PGConf US, in partnership with Ohio Linux Fest, is pleased to announce that the call for papers for PGConf Local: Ohio is now open.

    The inaugural PGConf US Local: Ohio Conference (PGConf Ohio) will be held September 29th - 30th at the Hyatt Regency Columbus Ohio (350 North High StreetColumbus, Ohio, USA, 43215).

    This two day, single track conference is a perfect opportunity for users, developers, business analysts, and enthusiasts from Ohio to amplify Postgres and participate in the Postgres community.
    The Call for Papers for PGConf Ohio can be found here.

    Call for papers will be open until Sunday, August 24th, 2017 and speakers will be notified of acceptance/decline no later than Monday, September 1st, 2017.

    Conference Schedule:
    • Friday, September 29, 2017: Trainings
    Mastering Postgres Administration: Bruce Momjian
    Postgres Performance and Maintenance: Joshua D. Drake 
    • Saturday, September 30, 2017: Breakout Sessions (To be announced)

    Registration for the     PGConf Ohio trainings is open now.

    Conference speakers receive complimentary entry to the breakout sessions on September 30th. The half-day training options on September 29th are separately priced sessions. As a nonprofit event series, funding is currently not available for speaker travel and lodging accommodations.

    Sponsorship Opportunities
    The PGConf US Local series is supported by its generous sponsors: Diamond Sponsor Amazon Web Services and Platinum Sponsors Compose, 2ndQuadrant, and OpenSCG. Please contact us if you are interested in joining our wonderful sponsors for Ohio or National!

    About PGConf US:
    PGConf US is a nonprofit conference series with a focus on growing the community through increased awareness and education of Postgres. PGConf US is known for its highly attended national conference held in Jersey City, New Jersey, and has expanded to a local series for 2017.

    The PGConf Local series partners with regional Postgres and open source groups to bring dynamic and engaging Postgres related content and professional training experiences to local communities. Host cities of 2017 include Philadelphia, Ohio, Seattle, Austin, and Cape Town, South Africa, with more locations to follow.

    Contact: organizers@pgconf.us

    Joshua D. Drake     August 15, 2017

    Community Days: BigApplePy and DockerNYC

    In 2016 we started working with horizontal communities. We wanted to make sure that PgConf US was an inclusive community that advocated not only for the best database in the world but also all the external Open Source technologies that make the best database in the world the best platform in the world. 

    This year we wanted to continue building a stronger community through relationships and our efforts are proving successful. We have joined forces with several horizontal communities to bring original and related content to PgConf US. The first is Big Apple Py. They are working with PgConf US to run a full track of Python content as well as a development workshop. 


    The workshop is particularly interesting as it will focus on a code sprint to develop a mature and user friendly Python based conference software. I wonder if they know we already use a Ruby on Rails solution...

    We also have a great workshop being presented by DockerNYC and Jesse White: Automating production ready databases in Docker
    DockerNYC
    PgConf US 2017 is less than two weeks away and we continue to work with communities to bring you even more new content! Stay tuned as we expect to announce more workshops in the next few days. If you haven't purchased your tickets, today would be a good day.
    Joshua D. Drake     March 15, 2017

    Community Profile: Alex Tatiyants and Pev

    We caught up with Alex Tatiyants after finding out about his Pev project. This is an awesome web based visual explain analyzer that is similar to the awesome explain.depesz . 

    Tell us a little bit (one or two paragraphs) about your project or how you use Postgres: 

    I created Pev (Postgres EXPLAIN Visualizer) to scratch my own itch. EXPLAIN generates a wealth of information, but isn’t easy to make sense of. I wanted to create a tool that helps me quickly diagnose problems with queries. Apparently, other people found it useful as well.


    Pev plan


    Why did you chose Postgres for your project? 


    Postgres is a fantastic database: performant, mature, feature rich, and of course open source. And in addition to being a first rate relational database, it has very strong document store features as well.


    Have you attended a PgConf US event or do you plan to? 

    I haven't had a chance to attend PgConf.

    Are you interested in contributing to the community further and if so, in what fashion? 

    I don’t have any concrete plans at the moment.

    Any closing comments? 

    Thank you for your interest.
    Joshua D. Drake     August 16, 2017

    PostgresConf US 2018, Financial Review



    The following table contains a summary profit and loss statement for PostgresConf US 2018.



    In review of these numbers two things will probably jump out at you:
    1. Venue and F&B of 238,000.12
    2. Net Revenue of 202,201.62
    Yes, we spent almost 250,000.00 dollars on the venue and food and beverage. In fact, the Food and Beverage alone was over 135,000.00 dollars. 

    We were fortunate to have very strong ticket sales as well as partner support through Sponsorships. This support will allow us to not only meet our financial requirements for PostgresConf Silicon Valley 2018 but will help us make our financial requirements for our European, Chinese, and US conferences in 2019. We are also hoping to set aside more money for our popular diversity and professional development initiatives.

    The Chairs would like to thank all our organizers, volunteers, partners and attendees for helping us continue advocacy of People, Postgres, Data!
    Joshua D. Drake     May 25, 2018

    PostgresConf Silicon Valley: Schedule now available

    PostgresConf Silicon Valley is being held October 15th-16th at the Hilton San Jose and the schedule is now available.


    The two day event received over 80 submissions! A lot of the usual and legendary speakers are present but we were pleasantly surprised to find that so many new (to the conference) speakers submitted. It shows that the mission of People, Postgres, Data is growing at an amplified rate. The presentations are all of the "best-in-class quality" our attendees have come to expect from PostgresConf events.



    Whether your needs are Big Data, Google Cloud, AWS RDS, GPDR Compliance, or you just have a burning desire to learn more about Kubernetes, PostgresConf Silicon Valley has you covered!

    We also have two fantastic training opportunities which are the first of their kind:



    Joshua D. Drake     September 04, 2018

    PostgresConf Silicon Valley 2019 dates and 2018 numbers!

    Announcing PostgresConf Silicon Valley 2019, September 18th - 20th at the Hilton San Jose! An absolute perfect pairing of training, breakout sessions, and a fantastic weekend break to enjoy the valley for every speaker, attendee, volunteer, and organizer. 

    Didn't you just host the community at PostgresConf Silicon Valley, you ask? Why yes we did! That event was October 15th and 16th of 2018. The event was such an unexpected success that we immediately started working with the hotel to lock in our dates for 2019. We requested mid-October to early November. Unfortunately, the only week they had available was the week of September 15th, 2019. We are again working with the Silicon Valley Postgres Meetup; the fastest growing Postgres meetup in the United States. 

    As we continue to be the fastest growing, non-profit, inclusive, and volunteer organized event we are providing you the breakdown of the Silicon Valley 2018 financials:


    PostgresConf Silicon Valley is much more cost effective than the "big" conference in Manhattan and that is exactly what we want as a development or "local" conference. We are targeting 50% growth for 2019 and we want do so in a way that is inviting to new community members that won't overwhelm them. We succeeded with that in 2018 and we are going to continue the mission of People, Postgres, Data!

    The global non-profit Postgres Conference Series


    Joshua D. Drake     November 14, 2018