Debra Cerda Blog Posts

Are you interested in learning about the latest developments and best practices in PostgreSQL? 

Then you won’t want to miss next week’s Postgres Conference Silicon Valley 2023! This annual conference brings together experts and enthusiasts from around the world to share their knowledge and experiences with the PostgreSQL community.

This year's conference will be held in San Jose April 20 and 21, 2023, at the San Jose Hilton, and promises to be another exciting and informative event. Attendees can expect a wide range of presentations, mini-tutorials, and networking opportunities, covering Postgres and open source related topics such as high availability, migration, security, machine learning, AI and much more.

Whether you're a seasoned PostgreSQL developer, a database administrator, or just curious about this powerful open-source database system, Postgres Conference Silicon Valley is the perfect place to learn and connect with like-minded individuals.

So why should you attend? For starters, you'll get to hear from some of the brightest minds in the PostgreSQL community. You'll learn about the latest trends and technologies, and gain valuable insights from real-world use cases and case studies. Check out our full program.

In addition, you'll have the opportunity to network with other PostgreSQL professionals and enthusiasts, and build relationships that can benefit you and your organization long after the conference is over. 

Be sure to stop by the exhibit area and chat with our incredible sponsors and partners, including our Conference sponsors CoreDB and Amazon Web Services (AWS) as well as our Cloud sponsor Google Cloud and Distributed SQL Summit (DSS) sponsor YugabyteDB. Our Conference Partners for this year include Airbyte, Command Prompt, Inc., DBeaver, Fujitsu, Neon, Nutanix, Percona, pgEdge and Community Partner OnGres.

Postgres Conference Silicon Valley is also a great chance to explore the local area, with plenty of opportunities for sightseeing, dining, and entertainment. A Welcome Reception will be hosted by YugabyteDB on Thursday evening for all registered attendees. 

So if you're looking to expand your knowledge of PostgreSQL, connect with other experts and enthusiasts, and have some fun along the way, be sure to register for Postgres Conference Silicon Valley today. We can't wait to see you there!

Postgres Conference 2025 in Orlando, held March 18–21, brought together PostgreSQL professionals from around the world for a week of deep technical learning, professional development, and intentional networking. With expanded tracks and thoughtfully curated sessions, this year’s gathering balanced core database expertise with a growing focus on holistic professional growth.

Event Highlights

• Expanded Tracks: In addition to the core DevOps, and Essentials tracks, the conference introduced Professional Development and Variants & Cloud tracks. These additions reflected the complexity of today’s tech environments and the evolving needs of those who manage them.

• Keynote Address: Malika Boukhelifa’s keynote, “Code Your Way Out of Burnout,” addressed the role of mental health in sustainable tech careers and provided attendees with strategies for long-term success.

• Technical Deep Dives: Popular sessions on pg_vector, analytics with DuckDB, and PostgreSQL partitioning strategies demonstrated the community’s interest in advanced features and real-world applications.

• Professional Development: The new track featured sessions on leadership, communication, and soft skills. Certified Wellness Coaches were also available onsite, offering support and tools to help attendees prioritize mental wellness alongside technical growth.

• Community and Networking: Conversations flowed freely in workshops, hallway meetups, and evening events like the tropical-themed buffet. The size and format of the event allowed for stronger peer connections and genuine knowledge exchange.

This year’s more focused format was intentional. The smaller scale fostered deeper discussion, better engagement, and more actionable takeaways. Whether tackling database replication or burnout prevention, attendees walked away with tools they could apply immediately. We would not be able to accomplish this without the generous support of our sponsors and partners.

Looking ahead, we plan to cap attendance in future years to preserve the quality and depth of the experience. Postgres Conference is no longer designed to be the largest event. Its goal is to be the most effective.

Want to stay updated on future Postgres Conferences and community news?
Subscribe to the PostgresWorld Substack for first access to upcoming events, announcements, and insights from the PostgreSQL ecosystem.

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

Elizabeth Zalman is the Co-founder & CEO of strongDM, the definitive data security product. Previously she was Co-Founder and CEO of the cross-device profile company Media Armor.

Liz will be presenting a breakout session "Do You Know Your Vendor Dependencies" on Wednesday, April 18, at 4 pm. Read what she has to say about Postgres and why to attend her session: 

Why PostgreSQL? What got you into it, and made you stick with it?

Featureful performance & proven reliability. Over the years I've found fewer and fewer reasons to consider alternatives beyond Postgres (two notable exceptions being redis-style KV and queues).

Tell us about your involvement with the greater Postgres community.

strongDM hears a lot about how its customers use PG and its derivatives (Greenplum, the latest on Aurora, etc.) and we love sharing tips when appropriate.

What new features of PostgreSQL 10 are you most excited about?

As a security product, we're always happy to see security-related upgrades: SASL/SCRAM authentication is a popular option in several of database systems, and is a significant upgrade over the previous salted hashes. We also rely heavily on partitioning, so all related enhancements are welcome.Finally: although we generally wouldn't choose to run parallel queries in a primarily OLTP system, the promise of running analytic queries on a replica (rather than ETL'ing into an analytic database) is very appealing.

What features should be developed/improved and released in the next major upgrade?

Dynamic optimization for queries on partitioned tables. Right now if you run select * from date_partitioned_table where event_timestamp between NOW() and NOW() - interval '7 days'; It scans every partition because the result of NOW() is not knowable ahead of time. But it could optimize that query when it was asked to execute it. Instead of creating a static query plan it could say, I know I'm going to have to compute a list of partitions. So, let's just remember that. Then right before the query runs, it could calculate the list and run the query as though it had been planned with a static date range, and thus only query the affected tables. 

 Why should attendees come to your talk at PostgresConf US 2018?

In this talk, I'll share practical examples of breaches I've personally experienced along with advice on how to hold your vendors accountable, and hopefully make the topic of security a little less intimidating in the process.

What sessions are you most excited about attending at PostgresConf US 2018?

I am looking forward to attending “Reducing the Surface Area of Risk in Data Security” by Tim Gorman and “General Data Protection Regulation (GDPR) with Azure Database for PostgreSQL” by Mark Bolz.

What is your favorite aspect of PostgresConf US?

Being able to network with and learn from a unique community! I’ve found practice to really be one of the best ways to learn about databases.

 What advice would you have for a Computer Science graduate or entry level developer who are interested in learning and engaging with Postgres? 

 I’ve found practice to really be one of the best ways to learn about databases. Get your hands dirty: try breaking things and then fixing them! 

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

As part of the countdown to Postgres Conference 2024, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Robert Bernier is senior PostgreSQL consultant at Percona.

Robert will present Working With The Citus Extension. Read what Robert has to say about Postgres and why to attend their session:

Why should attendees come to your talk at Postgres Conference 2024? What would you like for them to take away from your session?
For people who have heard about Citus but know nothing about it.
What is your favorite aspect of Postgres Conference?
Meeting my peers
What advice would you have for a Computer Science graduate or entry level developer who are interested in learning and engaging with Postgres and other open source technologies?
Data eats the world. Focus on learning about your data and how it's used.
How do you see the use of open source technologies evolving over the next five years?
PostgreSQL is a General Purpose Management System. It will come to dominate the DBMS world.
What considerations should be taken for the adoption and use of Postgres and related open source technologies?
Three talents:
- know your SQL
- know your OS (linux)
- know a programming language

Check out the full schedule for PostgresConf US 2024. Learn more about our conference here and buy your tickets soon!

As part of the countdown to Postgres Conference 2024, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Shayon Sanyal is a Principal PostgreSQL Specialist at Amazon Aurora, with over 15 years experience, and crafts resilient applications, leveraging PostgreSQL's advanced features.

Shayon will present Enhancing OLTP Systems with pgvector: Best Practices in Database Design. Read what Shayon has to say about Postgres and why to attend their session:

Why should attendees come to your talk at Postgres Conference 2024? What would you like for them to take away from your session?
The integration of pgvector into existing Online Transaction Processing (OLTP) systems represents a significant advancement in leveraging vector search capabilities within traditional database environments. This presentation is designed to educate database professionals on the thoughtful integration of pgvector into OLTP applications powered by PostgreSQL, ensuring enhanced functionalities without compromising the core transactional integrity and performance. Attendees will learn how to adopt pgvector to unlock new application features while maintaining reliability, performance and scalability of their PostgreSQL databases. The presentation provides a roadmap for practical pgvector integration regardless of the hosting environment.

What is your favorite aspect of Postgres Conference?
For me, the most amazing aspect of the Postgres Conference is the opportunity to learn from and engage with some of the most brilliant minds in the PostgreSQL ecosystem. The lineup of speakers and contributors is always exceptional, offering invaluable insights and perspectives that can shape the future of this powerful database management system. The depth and breadth of technical discussions from advanced database internals and performance optimizations to cutting-edge features and real-world use cases, the conference provides a platform for exploring the full potential of PostgreSQL. It's a true feast for those who crave technical excellence.

What advice would you have for a Computer Science graduate or entry level developer who are interested in learning and engaging with Postgres and other open source technologies?
My advice would be to dive in headfirst and immerse yourself in the open source community. Start by exploring the official documentation and resources provided by the PostgreSQL project. Don't be afraid to ask questions on forums, mailing lists, or community channels – you'll be amazed at how welcoming and supportive the community is, especially towards those eager to learn. Attend local meetups or online events focused on PostgreSQL and open source technologies. These are excellent platforms for networking, learning from experienced professionals, and staying up-to-date with the latest trends and best practices.

How do you see the use of open source technologies evolving over the next five years?
Increased adoption across industries: Open source technologies have already gained widespread acceptance in the tech industry, but I expect their adoption to accelerate across various other sectors, such as finance, healthcare, manufacturing, and government. As organizations recognize the benefits of open source, including cost-effectiveness, flexibility, and community-driven innovation, they will be more inclined to embrace these technologies in their mission-critical systems.
What considerations should be taken for the adoption and use of Postgres and related open source technologies?
If I had to pick 2 then - 1/ Community Support and Documentation: Evaluate the size and activity level of the community surrounding the open source project. A vibrant and engaged community is often a good indicator of the project's long-term sustainability and the availability of support resources, such as documentation, forums, and mailing lists. and 2/ Scalability and Performance: Thoroughly assess the scalability and performance capabilities of the open source technologies you intend to use, especially if you anticipate handling large volumes of data or high-traffic workloads. Conduct performance testing and benchmarking to ensure that the technologies meet your specific requirements. Then there are other considerations such as security and compliance, integration and interoperability etc.

Check out the full schedule for PostgresConf US 2024. Learn more about our conference here and buy your tickets soon!

As part of the countdown to PostgresConf Silicon Valley 2023, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Meet Ry Walker, Founder and CEO of CoreDB, which is currently in private beta. CoreDB "provides provides a fully-managed, secure, scalable Postgres cluster with access to an ecosystem of extensions, expanding the capabilities of a database." Ry is a long-time coder, founder investor and champion of open source. He enjoys nature, science, art, tennis, platform tennis, golf, basketball, fishing and indie game development.

Read what he has to say about Postgres and why to attend his keynote session "The Growing Postgres Ecosystem" on Thursday, April 20th:

Why Postgres? Tell us about your involvement with the greater Postgres community.

I've been a user since the beginning, recently started CoreDB which will provide a managed Postgres SaaS.

Why should attendees come to your talk at PostgresConf US 2023?  What would you like for them to take away from your session?

Learn about exciting Postgres extensions and what CoreDB is planning to contribute to the ecosystem

What is your favorite aspect of Postgres Conference?

I'm a first timer :)

What advice would you have for a Computer Science graduate or entry level developer who are interested in learning and engaging with Postgres?

Blog about your journey.

 What's your top suggested readings for 2023?  Books, blogs -- from fiction to non-fiction to technical, anything you enjoy?

The Hobbit :)

What do you believe are the major achievements of open source and Postgres over the last decade?

The rise of open source and open core companies is exciting!

Check out the full schedule for Postgres Conference Silicon Valley 2023, and buy your tickets soon!

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

Abbas Butt is a Software Architect at EnterpriseDB, and he will present a half-day training "Deep dive into PostgreSQL Authentication Methods" on Monday, April 16, at 1 pm. Learn more about Abbas and his involvement in the Postgres community:

Why PostgreSQL?

My company's business revolves around PostgreSQL.

Tell us about your involvement with the greater Postgres community.

I have been involved with PostgreSQL for about 10 years. Over the years I have contributed by reporting bugs and developing various FDWs. I have also worked to make PostgreSQL an XA complaint database by using a modified version of pgBouncer. My next plans are to come up with small programming exercises with solutions to accompany this book http://www.interdb.jp/pg/ ("The Internals of PostgreSQL for database administrators and system developers"  by Hironobu Suzuki). This will give the readers hands on experience.

What new features of PostgreSQL 10 are you most excited about?

Declarative table partitioning & query parallelism

What features should be developed/improved and released in the next major upgrade?

Write Scalability and High Availability

Why should attendees come to your talk at PostgresConf US 2018? What would you like for them to take away from your session?

Attendees should come to have great time learning about PostgreSQL authentication methods. After attending the session the attendees will be better placed to decide which authentication scheme should they use and why.

What sessions are you most excited about attending at PostgresConf US 2018?

"Aurora PostgreSQL Tutorial and Extended Deep Dive" and "Know your meme: Develop a webapp using Google Cloud Kubernetes and Cloud SQL"

What is your favorite aspect of PostgresConf US?

Being able to listen and exchange point of views with other community members.

What advice would you have for a Computer Science graduate or entry level developer who are interested in learning and engaging with Postgres?

Read this book : "The Internals of PostgreSQL for database administrators and system developers"  by Hironobu Suzuki.

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