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 

• PostgreSQL v10 an Amplified version of Postgres!
• Using Kubernetes/Docker/Helm to Deploy On-Demand PostgreSQL Streaming Replicas
• Postgres Window Magic
• BDR Around the globe

• Diamond: Amazon Web Services
• Platinum: Compose, OpenSCG, 2ndQuadrant
• Partner: Quest
• Supporter: Command Prompt
• Media: @amplifypostgres

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

Why did you chose Postgres for your project? 

Tell us about your commitment and contribution to the Postgres Community

For over 10 years, EnterpriseDB (EDB) has been working with the community and enterprises to drive Postgres forward. EDB is one of the top PostgreSQL community contributors. Two of our team members are part of Postgres Core team, while 4 are committers, and 6 are named contributors. We invest heavily into Postgres performance, scalability, availability, migration, integration and support to make sure that enterprises can take advantage of Postgres' rapid innovation cycle and advanced capabilities.

What growth pattern do you expect for yourself as well as Postgres as a whole?

Postgres adoption is exploding and we can see that in our business results. Today, we support 92 of the Fortune 500 and 311 of the Forbes Global 2000. Our customers look to us for a reliable, high-performing, and cost-effective data management platform based on open source PostgreSQL.

Our customers are using EDB Postgres for mission critical applications. Their databases range all the way up to 50 TB with some handling over 50K transaction per second in environments that require 99.99%+ availability.

Our customers’ confidence in Postgres and EDB is no surprise. Postgres has been the #1 open source relational database in the DB-Engines.com rankings for two years in a row and EnterpriseDB has been chosen for the Gartner Magic Quadrant for Operational Database Management Systems for six years in a row.

How do you plan to assist Postgres in the future?

EDB continues to invest heavily in Postgres with key projects such as zHeap, Just-in-Time (JIT) compilation, and other efforts focused on performance and scalability.

What is the number one benefit you see within Postgres that everyone should be aware of?

EDB Postgres has become the general purpose database of choice for digital transformations, offering JSONB document support, GIS-support, EDB Postgres Oracle® compatibility features, key-value pair data, and increasing capabilities for analytical workloads. It has the fastest innovation cycle, the best deployment models, and the lowest cost of any commercial relational database.

What is the best thing about working with the Postgres community?

The best thing about working with the Postgres community is their fast innovation, resulting in extremely reliable code.

Tell us why you believe people should attend PostgresConf 2019 in March.

PostgreSQL is one of the oldest and most stable open source projects as a result of the commitment of its members and its independence as a stand-alone community. Over the years, Postgres has achieved parity with proprietary platforms in terms of performance and functionality. It has received a warm welcome from businesses looking to roll back database costs and ease vendor lock-in, and leading companies are adopting it with great success. This is just like it was with Linux 15 years ago. Enterprises understand that they have to adopt Postgres or they will be left behind.

It is late August, 2019. This is the time where we are usually prepping for the very busy fall season and not much else. However, this is the Year of Postgres and everyone is driving 200MPH down the ecosystem highway (321.8688/KPH). We are going to kick off this newsletter with some exciting information about the community.

Events

PostgresConf has launched Digital Events! The goal of Digital Events is to open our education platform year round to all members of the community. Our first series of events will be held with our ecosystem partner YugabyteDB and their “Distributed SQL Webinar Series.” This is a series of free-to-attend Webinars exploring Distributed SQL from leaders in the field.

PostgreConf Silicon Valley tickets are going at a brisk pace and half day trainings are almost sold out. Register today to reserve your seat before prices go up on September 1st!

Right after Silicon Valley, PostgresConf South Africa is kicking off. This conference has grown by leaps and bounds over the last two years. We highly recommend attending for anyone who can!

PGConf.IN (India) has announced that their conference will be held in February 2020!

Meetups

We have seen the launch of three new meetups this month:

• Los Angeles Postgres The first meetup is planned for late October or early November as we continue to build the Silicon Beach community.
• Toronto Postgres Similar to Los Angeles, the first meetup is planned for late October or early November.
• Charm City Postgres This meetup was formed by long time community member Robert Treat.

Several other meetups are growing quickly: 

• Montreal Postgres has reached a respectable 358 members.
• Vancouver Postgres has reached over 400 members.
• Seattle Postgres has begun to grow again with a new schedule of events!

Interested in speaking or hosting a meetup? Contact us and we’ll connect you with the right people! 

Learn

Here is a short, great introduction tutorial on running PostgreSQL in Docker by Igal Sapir, Los Angeles Postgres organizer. Everybody has 13 minutes.

Shawn Wang from our friends at High Go has provided an insightful write-up on AES Performance.

Ecosystem

TimescaleDB is running a “State of Postgres” survey. Please take five minutes and help them out! They have also announced a new Distributed Timeseries product.

VMWare has just acquired Greenplum and PostgreSQL supporting company Pivotal.

Postgresql.org

PostgreSQL versions 11.5, 10.10, 9.6.15, 9.5.19, 9.4.24, and 12 Beta 3 are now out in the wild and addressing several important security concerns and bug fixes.

---

Have news you’d like included in future newsletters? Contact us.

Postgres Conference organizers come to us through a variety of channels, but they all have their own unique story and pathways. Unlike many of our organizers, Lindsay Hooper’s background is non-technical and focused on the logistics, partnerships, and outcomes of Postgres Conference. Read on to learn more about her and her non-profit organization of choice

What is your background?

I majored in art and film at Bucknell University, and I started my career working in art galleries in Manhattan. I quickly moved to events and marketing, and within a few years I started doing events and marketing for tech companies and startups.

What do you do in your full-time job?

I have my own events company called LRH Events, and most of my clients are either in the non-profit or tech worlds. Events are a great tool for gaining brand awareness and for creating community, but getting an event off the ground takes some serious marketing chops, and so I do marketing as well.

What’s your favorite part of Postgres Conference?

There’s so much to love about Postgres Conference. When it comes to the conference itself, I love the logistics and planning that goes into what the event actually looks like. I love everything from brainstorming what the conference should look and feel like, to coordinating with speakers, streamlining talks, and coming up with schedules.

Beyond the actual events, my favorite part is the People, Postgres, Data community that surrounds the organization. I’ve never experienced such a truly people-first group, and I think that that shows in the fact that this isn’t a twice a year conference - it’s a constant connection that’s focused on people, not just Postgres or open source technology.

How do you spend your free time?

I am based in NYC, which affords me the opportunity to spend a lot of my free time exploring the city’s restaurants and museums. I highly recommend an afternoon at The Met, followed by dinner down in the East Village at either Raclette or Dirt Candy. 

Beyond that, I’ve been involved with a non-profit called Mouse for the last five years, so I also spend a few evenings each week working on fundraising and awareness initiatives. Mouse’s mission is to provide vulnerable youth with the computer science skills needed to enter and succeed in higher education and the high tech workforce. We are committed to fostering greater diversity and humanity in STEM and empowering youth - and all those that educate them - to access and amplify technology as a force for good.

How did you begin working with Mouse and what’s your role there?

I started working with Mouse five years ago when they launched the Diversity in Tech Awards, which is their annual awards event that honors folks in the tech ecosystem who foster greater diversity and humanity in STEM and empower youth. They needed event support, and I was able to step in to help.

Since then, I joined Mouse’s associate board, became the VP, and am currently the Associate Board President. 

What are the biggest challenges facing STEM education right now?

The greatest challenges facing education as a whole have shifted in the last few months due to the COVID-19 pandemic. In speaking with Mouse students, I’ve learned that a lot of what they’re up against is the variety of platforms that they’re receiving school work on and the lack of collaboration. On the flip side, most teachers are experiencing a learning curve themselves when it comes to remote teaching.

During the COVID-19 crisis, Mouse has played a frontline role in meeting the emergency educational needs. Responding to a call from the NYC Department of Education after schools closed, Mouse has:

• Trained more than 4,000 teachers in online teaching methods so they can reach their students.
• Helped more than 100,000 NYC students get access to online learning
• Digitized youth programs like the Emoti-Con Virtual Showcase and Mouse Design League for students to continue their computing projects
• Made our STEM and computer science learning platform, Mouse Create, free for all users during the crisis

How can I get involved in Mouse?

If you’re interested in getting involved with Mouse, please feel free to reach out to me directly at Lindsay@postgresconf.org

Alternatively, Mouse is proud to be able to continue our work with students and educators during the COVID-19 crisis. Please give generously today at www.mouse.org/donate so we can continue to make great strides in finding new ways to help our community in these challenging times. 

At Postgres Conference we are always optimizing our People, Postgres, Data experience, and as more events move to Digital,  we have worked hard to perfect that collaborative experience for our community. The hard work of our volunteers has paid off, our content is top notch, and our participant account is consistently high.

With a now-proven track record, we are pleased to announce that we are accepting Community and Commercial presentations via the Postgres Webinar Series Call for Presentations through the end of 2020. If your presentation is accepted we will contact you directly to arrange an appropriate time to deliver your content.

Recent awesome news

KDE, arguably the most complete desktop experience for Linux, is now hosted on a private instance of Gitlab. As is proper, Gitlab only supports Postgres as the backend database.

For those who who love #FarmFresh or #farmtotable, there is a new website that showcases Farms that are delivering. It was developed using React, Rails, and Postgres. 

Upcoming Digital Events

• July 7, 10am PT: Deep Dive into PostgreSQL Indexing

A Deep Dive into PostgreSQL Indexing

• July 15, 10AM PT: Working with JSON Data in PostgreSQL vs. MongoDB

Working with JSON Data in PostgreSQL vs. MongoDB

Previous Digital Events:

• PostGIS Training series:
• Getting Started with PostGIS and OpenStreetMap by Ryan Lambert
• Advanced Operations and Features by Ryan Lambert
• Exploring OpenStreetMap from PostGIS:  Tools and Queries by Ryan Lambert
• Loading PostGIS with osm2pgsql by Ryan Lambert
• PostGIS Spatial Queries and Performance Tuning by Ryan Lambert
• PostgreSQL 12 and PostGIS 3.0 by Ryan Lambert
• Ops:
• FPGA: an Easier Path to Parallelism for Postgres? by Andrew Ellicott
• How to Deploy a SQL Database on Kubernetes by Chris Casano
• How to Move Data from Oracle to Postgres in Near-Real Time by Joshua Drake
• A Deep Dive into PostgreSQL Indexing by Ibrar Ahmed
• Mostly mistaken and ignored PostgreSQL parameters while optimizing a PostgreSQL database by Avinash Vallarapu
• Deeper Understanding of PostgreSQL Execution Plan: At plan time and run time by Jobin Augustine
• A Deep Dive into PostgreSQL Indexing by Ibrar Ahmed
• Enterprise Authentication and Connection Pooling by Erik Brandsberg
• Case Studies
• YugabyteDB: a distributed PostgreSQL database by Bryn Llewellyn
• Community vs. Enterprise Open Source – Which is Right for Your Business? by Justin Reock
• Postgres vs. MongoDB for real-time machine learning on wind turbine data by Luis Manuel Carril
• Turning PostgreSQL into a Cloud Native Data Service by Julian Fischer
• Scaling PostgreSQL: Never Shard Again and Gain Effortless Scale by Jim Walker
• Bring Compression to Postgres at Zero Cost of Performance by Tong Zhang

As part of the countdown to PostgresConf US 2018, learn more about the engaging content and our Diamond and Platinum sponsors for this year in our Sponsor Spotlight Series.

Jacque Istok, is the Head of Data for Pivotal, one of our Diamond Sponsors for PostgresConf US 2018. Pivotal is hosting the first annual Greenplum Summit at PostgresConf US 2018, with lots of great Greenplum and Postgres-related content. Read what Jacque has to say bout Greenplum and Postgres, as well as why to attend the Greenplum Summit: 

Greenplum is an Open Source variant of Postgres; what benefits do you bring to the table over vanilla Postgres?

Postgres is a powerful ORDBMS, but as your data scales, the only way to keep up is to buy bigger and bigger machines to run on. It suffers from the same problems that all SMP databases do: you can only get as big as the machine you’re running on.

With Greenplum you can put a subset of your data on a Postgres database on one reasonably-sized machine, and another subset on a second machine, and so on. All of your users and applications can then query one of these Postgres databases as if all the data was in a single location - making your data scale limitless. Greenplum manages the distribution, data shuffling, and querying of all of your data across a magically sharded implementation of Postgres databases.

Greenplum has its own community; what do you hope to achieve by joining the Postgres community and PostgresConf?

The Postgres community represents some of the most passionate and knowledgeable creators, developers, and users of database technology of our time. We believe that the combination of Postgres and Greenplum becomes the software equivalent of what Oracle Exadata purported to be: an all-purpose database that can do both transactional and analytical workloads across multi-structured data. Simply put, the Greenplum community is looking to join with the Postgres community to further the understanding and adoption of these technologies.

Do you have plans for cross pollination of technologies with the two open source projects?

Greenplum forked from Postgres over 10 years, circa Postgres 8.2. Greenplum 5.0 is based off of Postgres 8.3, with our next major release slated for Postgres 9.4 (current open source Greenplum is compatible with 9.0 as of this writing).

Likewise, we have Postgres committers working at Pivotal looking for opportunities to improve the Postgres code specifically for analytics. We are also ensuring that other projects related to Greenplum, like Apache MADLib, continue to be compatible with Postgres.

What challenges do you see working with the Postgres community as an open source fork?

The Postgres community is a long-running and very passionate group, and we want to be both collaborative and respectful in how we continue to grow our participation. We see the products as having synergies which complement each other very well, with some use cases that best fit Postgres, and others that best fit Greenplum. The use of either benefits the other as they both further adoption.

What would you tell a user who has a choice between Postgres and Greenplum about when they should use which system?

Postgres is a great ORDBMS that will scale to the performance of a single server. For analytical needs, being restricted to a small number of terabytes does not allow for the type of exploration that most organizations need. Because Greenplum is a Postgres compatible database, you can start out using Postgres and either convert to Greenplum underneath or leverage Greenplum alongside your Postgres systems (making data ETL a ton easier). This then makes the choice of which product to use for your particular use case clearer and clearer.

What is the number one barrier you see to contributing to the Postgres community?

The number one barrier we will have to contributing is not seeing the corresponding adoption of our technologies. We feel very strongly that both the transparency and removal of vendor lock-in make our open source commitment the only choice for users. I’m here to implore the community to embrace our technology with zeal and help us continue to drive more and more Postgres adoption in the world.

What is the best thing about working with the Postgres community?

Because Greenplum is based on Postgres, we get to interact with this vast community of talent. We are also able to more seamlessly interact with ecosystem products that already work with Postgres, making the adoption of Greenplum that much easier.

Tell us why you believe people should attend PostgresConf 2018 in April.

PostgresConf is going to be awesome - with both Pivotal and Amazon headlining as Diamond sponsors - as well as the quality of speakers and their content. I wouldn’t miss it for anything.

We’re thrilled to organize the first annual Greenplum Summit at PostgresConf. Greenplum co-founder, Scott Yara, will give a keynote on April 18th relating to how data tells the story at the organizations that we help enable (#DataTellsTheStory), and his journey from SMP to MPP. Greenplum Summit on April 19th will be a full day packed with with great use case sessions and tech talks for novices and experts alike.

Check out the full schedule for PostgresConf US 2018, and buy your tickets soon!

PostgresConf US 2018 is in 9 days. Here is the obligatory "Buy your tickets" reminder! If you look around (a Google search of Gold sponsor Google Cloud is a good place to start) you will find a lot of discount codes.

In 2017 we launched a community wide effort to better recognize contributors for not only the conference but the wider Postgres Community. We continued this effort in 2018 and are pleased to have many speaker profiles available, with more being published every day:

• Les McMonagle
• Malcolm McLean
• Elizabeth Zalman
• Hubert Zhang of Pivotal
• Baron Schwartz
• Jignesh Shah
• Tim Gorman
• Tom Limoncelli

• https://www.pgconf.us/conferences/Philly2017

• https://www.pgconf.us/conferences/Philly2017/sponsors