Select Page

PGConf NYC 2023 Event Recap

Author: Shailesh Rangani | | October 18, 2023

I was happy to be back in NYC for PGConf NYC 2023 – last year was a great experience! This event brought together developers, DBAs, researchers, decision-makers, and contributors to the open-source PostgreSQL community. The Datavail team also met with their cloud partners Microsoft and AWS.

Datavail was once again a Gold sponsor, and we gave away Beer for a Year, Datavailopoly, the only board game for DBAs, by DBAs, and other fun prizes.

PGConf NYC 2023 featured a wide range of sessions and activities. There was a lot of buzz around the release of PostgreSQL 16, new database trends, and of course, generative AI. A few sessions I want to highlight in this recap include:

  • Supporting GenAI workloads in PostgreSQL: Shayon Sanyal, AWS, delivered an insightful talk about the integration of embeddings generated using large language models (LLMs) with the pgvector open-source extension for PostgreSQL. This integration offers a powerful solution for optimizing the product catalog similarity search experience through pre-trained ML models and vector embeddings.
  • Trusted Language Extension for PostgreSQL: Peter Celentano and Sukhpreet Kaur Bedi, both AWS, shared their expertise on adding custom extensions to PostgreSQL without writing them in C. It focused on leveraging Trusted Language Extensions for PostgreSQL on AWS, utilizing trusted PostgreSQL languages such as PL/pgSQL, Perl, and Rust.
  • What’s new in PostgreSQL 16: Magnus Hagander, PostgreSQL Core Team, dove into the exciting new features and capabilities of PostgreSQL 16.

I also gave a PGConf NYC 2023 presentation on Upgrading and Testing Rollback of a Multi-TB Amazon Aurora PostgreSQL Database Using Blue-Green Deployment.

Upgrading large, multi-TB databases to higher versions requires a lot of planning and testing. There are several methods you can use to perform Amazon Aurora PostgreSQL upgrades. In this session, I went over how to use Amazon Aurora’s rapid database cloning feature for a real-world Blue-Green deployment approach with near-zero downtime. In my presentation, I also covered other use cases of Aurora PostgreSQL blue/green deployment.

PGConf NYC 2023 was a great event and I look forward to next year!


Amazon RDS vs Amazon EC2 | Amazon Web Services EC2 vs RDS

Ready to migrate your MySQL database to Amazon Web Services (AWS)? Which is better, Amazon RDS or Amazon EC2? Learn the pros and cons of each option.

Charleste King | September 7, 2017
Oracle cloud analytics

Art of BI: What is Oracle Analytics Cloud and Why Should You Care?

Read on to learn about the release of Oracle Analytics Cloud, a service that includes Essbase Cloud, Business Intelligence Cloud, and more.

Christian Screen | June 8, 2017

MongoDB and AWS- A Perfect Match

Amazon now supports MongoDB migration onto its AWS platform. Find out why MongoDB and Amazon S3 combination is a perfect match for the database infrastructure.

Esayas Aloto | October 3, 2017

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.