Debra Cerda Blog Posts

As part of the countdown to PostgresConf US 2018, learn more about about featured Platinum Sponsor 2ndQuadrant, including their commitment to partnering with and contributing to the Postgres community, from Simon Riggs, Chief Technology Officer, of 2ndQuadrant and PostgreSQL Major Developer/Committer:

Tell us about your commitment to the PostgreSQL Community.

The 2ndQuadrant vision is to be the bridge between the database needs of enterprise users and open source contributions to PostgreSQL. We have pursued a joint strategy of providing both working code (available now) and later submitting the features into core PostgreSQL. Over the past 15+ years, our team has widely contributed to the growth and development of the PostgreSQL project; partnering with customers to identify bottlenecks and then contribute towards enterprise features that address them in PostgreSQL, benefiting everyone that uses it. Besides contributing code, all members of the 2ndQuadrant team are very active in the community on an individual and local level, often helping to organize PUG events, conferences, and meetups.

Are there any rising stars in the community you’d like to give props to? 

Marco Nenciarini - located in Prato, Italy - has been a long time supporter and contributor of PostgreSQL. He is an active maintainer of PGDG’s APT repository, maintaining builds and binaries for PostgreSQL and associated tools & extensions, while contributing towards process improvement for sane builds. Marco is the lead developer for Barman, a backup manager and disaster recovery tool for enterprises with high business continuity requirements.  He is the current president of IT.PUG in Italy and a part of the organizing committee for PGDay.IT.

What features would you like to see in v11 and v12?

As PostgreSQL matures, so do the features that come with each release. In the next two release we’re most looking forward to improved Partitioning performance, the implementation of the MERGE SQL command, and procedures that allow server-side transactions.

Are there any features in development from 2ndQuadrant that the community should be looking forward to?

2ndQuadrant is working hard on the development of Bi-Directional Replication (BDR3), containing new architectural features and a wide and deep set of features.

In addition, we continuously work on features for scalability, performance, security and robustness.

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

The Postgres community is one of the easiest communities to become a part of. With an open mindset all around and a common goal of growing open source PostgreSQL, the community is very accepting to anyone looking to learn, contribute, and better the Postgres ecosystem as a whole. Between the helpful tools on postgresql.org and the growing community, comprised of seasoned veterans and fresh faces, there is always helpful information to guide you.

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

PostgreSQL is the most popular database when it comes to new adoption. Even existing users of other databases are flocking towards PostgreSQL - and it’s not just to save money. PostgreSQL has been growing year on year and we’re attracting interest from the largest enterprises, as it is fully capable of securely supporting enterprise database systems. 

There is still competition out there, especially with the current fad of developer-focused NoSQL databases. But the community is big enough and strong enough to quickly adapt to changing times and push forwards. The members of the PostgreSQL community are passionate about their work and the growth of the project.

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

Community conferences expand your knowledge in different areas of the technology, describe practical use cases as well as give sneak previews into cutting edge technologies for future versions of PostgreSQL. 

Simon along with Tom Kincaid, General Manager of 2ndQuadrant, presents "Internet of Things with PostgreSQL - Performance & Security" on Friday, April 20, at 8:50 am. Tom also presents "Postgres -- Past, Present and Future" and will discuss the challenges that may be faced by Postgres in the next 5 years on Thursday, April 19, at 3:20 pm. 

Visit the 2ndQuadrant team in the Exhibit Hall in the Newport Grand Ballroom on Wednesday, April 18, and Thursday, April 19.  

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

Attention PostgresConf US 2018 registered (and potential) attendees -- our discounted room block at the Westin Jersey City Newport has sold out! We have arranged to add an additional small block, lasting until Monday, March 26th or until it sells out.

HOWEVER, these rooms are selling fast so make your reservation ASAP if interested in staying at the Westin with the special conference rate of $260/night plus applicable taxes for attendees who make their reservations via the dedicated Westin webpage or via telephone (888) 627-7148.

If booking via telephone please mention "PostgresConf US 2018" to receive the group rate. Guest room wifi is included in the room rate.

The Westin Jersey City Newport is the best place to stay and enjoy all conference activities. Attendees will mingle at the Westin bar and hallways throughout the afternoon and long into the evening.

Additional Lodging Options

The DoubleTree by Hilton Hotel Suites Jersey City and the Courtyard Jersey City Newport  are two conveniently located hotels just a short walk from the conference. Rooms may be booked via their respective websites.

PostgresConf US Attendee Poll - Action Needed!

Our PostgresConf US 2018 poll is now open -- your input is valued!

Please take two minutes to provide feedback so we can ensure that the conference is a great experience. Registered attendees should have received an email this week with the poll link. Contact us at organizers@postgresconf.org if you did not receive the poll link.

The purpose of this quick poll is to note any dietary restrictions and gauge interest in the Greenplum and RIS Summits, as well as some of our popular sessions so that we can assign room spaces accordingly

Sponsors

During PostgresConf, you will have plenty of opportunity to meet our great sponsors, including:

• Diamond: Amazon Web Services, Pivotal
• Platinum: Compose, OpenSCG, 2ndQuadrant, Microsoft
• Many more!

For more information, please visit our website https://postgresconf.org/conferences/2018.

Need further assistance? Contact us at organizers@postgresconf.org.

We look forward to seeing you in April in Jersey City!

We are excited and humbled that Malika Boukhelifa will be the Keynote Speaker for Postgres Conference 2025 in Orlando. Her keynote “Code Your Way Out of Burnout” will explore how burnout happens and how we can recover without compromising our health.

About Malika Boukhelifa:

• PhD in Cell Biology (University René Descartes Paris, France)
• Integrative Health Coach and founder of Founding Momentum, LLC
• Extensive Experience in Research & Development across academia, biotech companies, and startups in the US, France, and Germany.

This session is part of our Professional Development track, designed to help attendees grow not just as technologists, but as well-rounded professionals. Don't miss this opportunity to gain valuable insights and strategies for sustainable success.

Register now and book your hotel to join us for an unforgettable conference experience!

* Book by March 4th to receive our preferred discounted rate at the conference hotel

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.

Dave Stokes is author of "MySQL & JSON - A Practical Programming Guide," and serves as a Technology Evangelist for Percona, advocating for MySQL innovation and best practices.

Dave will present “MERGE() - A Quick Introduction”. Read what Dave 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?
I like to show attendees new facets on old tools and help beginners master the very steep learning curves of today's world.

What is your favorite aspect of Postgres Conference?
The hallway track.

What advice would you have for a Computer Science graduate or entry level developer who is interested in learning and engaging with Postgres and other open source technologies?
You learn by breaking and repairing. After awhile you can learn to minimize the breakage but never the repairing.
And when you go to a show like Postgres Conference 2024 and have an open slot in the schedule, go attend a session on a subject you know absolutely nothing about. You will either learn that you do not like the subject and have only spent an hour of your life on something that does not interest you, or you will find another rabbit hole to explore.

How do you see the use of open source technologies evolving over the next five years?
PostgreSQL will be the dominant database. Sadly license changes may push us back to a pre-open source era when you had minimal or no choices in software.
What considerations should be taken for the adoption and use of Postgres and related open source technologies?
It needs to be more robust. Better replication that is easier to set up, no XID wrap-around, and easy upgrades.

Additional comments?
This is a great show - make the most of your opportunities.

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.

Tatiana Krupenya is CEO of DBeaver Corp, an information technology company with many years of experience developing database management tools. DBeaver has created a full-featured data solution that easily adapts to users' needs, from open-source tools to all-in-one enterprise software. PostgreSQL is one of the most popular databases among DBeaver users.

Tatiana will present "Looking for the differences in your data". Read what Tatiana 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?
If you have ever tried to compare the data between tables, you know that it's not so obvious. It's not difficult if your table has a few tens of rows. You can easily do this visually. But what if you have thousands or millions of rows? Let's review the possible ways to compare this amount of data together.
What is your favorite aspect of Postgres Conference?
The best at any Postgres Conference is the Postgres Community. An opportunity to talk to people who are inspired by technology and ready to share their own experiences is invaluable. The conference is a place where you can feel what is the open-source culture.
How do you see the use of open source technologies evolving over the next five years?
There are no limits to open source. I am happy to see that big corporations invest more and more resources in open source. I believe that open source is not charity but a quality sign. Open source is always on the edge of technologies; it's flexible, and it's open to new. It's hard to predict how exactly these technologies will evolve over the next five years, but there are no doubts that open source will have an important place there.

Check out the full schedule for PostgresConf US 2024. Learn more about our conference here and buy your ticket! Walk-up registration is available onsite.

Are you ready to take your career to the next level? Whether you're a seasoned technology professional or just stepping in, the Professional Development track at Postgres Conference 2025 is your gateway to success.

This year, the Professional Development track offers a curated lineup of sessions designed to equip you with the skills, strategies, and insights to thrive in an evolving tech landscape. The conference takes place from March 18 - 21, 2025, and will be hosted at the beautiful DoubleTree By Hilton Hotel At The Entrance To Universal in Orlando, Florida.

What to Expect

The Professional Development track goes beyond the technical deep dives of other tracks—it’s all about empowering you to grow as a professional. Some key highlights include:

• Leadership and Team Building: Learn how to lead high-performing teams in the fast-paced world of database management.
• Career Growth Strategies: Gain actionable insights into advancing your career, from presentation tips to navigating complex workplace dynamics.
• Soft Skills for Tech Professionals: Enhance critical skills like communication, conflict resolution, and cross-team collaboration.
• Navigating Change in Tech: Hear from industry leaders about how to adapt to the shifting demands of the tech industry while staying ahead of the curve.

Whether you're a database administrator, developer, team leader, or someone looking to transition into Postgres-focused roles, this track is tailored to your professional growth.

Who Should Attend?

The Professional Development track is ideal for:

• Emerging Professionals: If you're new to the tech industry or transitioning into a Postgres-related role, you'll find valuable guidance to kickstart your journey.
• Seasoned Experts: Even the most experienced professionals can refresh their skills and stay ahead of trends.
• Leaders and Managers: Gain new tools for leading teams, managing stress, and fostering innovation in your organization.
• Tech Enthusiasts: If you're looking to grow personally and professionally within the tech industry, this track is for you.

Why You Should Register Now

Don’t miss this opportunity to invest in yourself and your future. The skills and insights you’ll gain at Postgres Conference 2025 could make the difference in your next career move or project success. Secure your spot and begin planning your schedule for the event.

Ready to take the next step? Register now for Postgres Conference 2025 and reserve your place in the Professional Development track. Early bird discounts are available, but only for a limited time—don’t wait!

Transform your career. Grow your network. Build your future. Join us at Postgres Conference 2025 and make this your year of professional development.

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.

Baron Schwartz is the founder and CEO of VividCortex, the best way to see what your production database servers are doing. Baron has written a lot of open source software, and several books. He’s focused his career on learning and teaching about performance and observability of systems generally (including the view that teams are systems and culture influences their performance), and databases specifically.

Baron will be presenting a breakout session "How To Index Your Database" on Friday, April 20th at 12:50 pm. Read what he has to say about Postgres and why to attend his session: 

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

The community has always been what’s drawn me to Postgres. From the very first I could immediately sense the deep commitment people had to the database and other people involved with the database. Each database community is special in its own way and has its own culture, and after being involved in many of them you sense it in a way you can’t explain. Postgres’s is loyal to freedom, independence, quality, and principles. All are dear to me as well.

Tell us about your involvement with the greater Postgres community.

I’ve participated since 2008 in various ways. I’ve blogged, written open source, written books, reviewed and tech-edited other people’s books, spoken, and attended. I hope to continue doing so!

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

Partitioning! Improved streaming replication! Parallel query execution! There are so many improvements. The pace of development is really impressive.

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

The database of the microservices-oriented future is only quasi-stateful. By this I mean that it acts almost like a read-through cache in front of “cold storage” like S3. Support for creating an empty database cluster, and having it fetch its data from cold storage on first query, would be game-changing for cloud-native apps. I realize that’s a lot of buzzwords, but it’s going to happen soon!

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

Indexing is at once the most important, simplest, and most complicated topic in designing a database; I hope to make it simpler and leave people with three big things they will never struggle to remember.

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

I'm really interested in hearing how others are using Postgres, both for creative purposes that showcase its flexibility and extensibility, as well as "use as designed." In my opinion, the best conference talks aren't "you should do this"; types of talks: they are "I did this and here's what happened"; I love stories!

What is your favorite aspect of PostgresConf US?

That’s an easy one to answer: seeing all my old friends again!

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

Computer Science seems to feel that algorithms, data structures, and so on are fundamental. Data persistence, especially relational, is equally important. Don’t neglect.

You can invite any three living people from anywhere in the world to dinner. Who do you invite and why?

I invite the three hungriest people in the world and eat mindfully with them, so I learn to appreciate what I have.

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.

Chandra Pathivada is is a Senior Database Specialist Solutions Architect with Amazon Web Services. He works with the AWS RDS team, focusing on Open Source database engines like RDS PostgreSQL, Aurora PostgreSQL, and Babelfish for Aurora PostgreSQL.

Chandra will present “Why PostgreSQL Isn't Utilizing Indexes: Diagnosing and Solving Performance Issues" and "Behind the Scenes: Demystifying Transaction Isolation in App Development". Read what Chandra 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?
This talk dives into the core concepts, shedding light on the real-world implications of different isolation levels on performance and integrity. Through interactive examples and case studies, attendees will learn how to navigate common pitfalls and optimize application performance, balancing concurrency with isolation effectively. Gain the knowledge and best practices necessary to implement error-free database-backed applications, making it an invaluable opportunity for anyone looking to enhance their expertise in database management and application development.

What is your favorite aspect of Postgres Conference?
Engage with the PostgreSQL community. This conference offers a rich tapestry of learning, sharing, and networking. It's where boundaries of knowledge expand through collaboration and where every attendee, regardless of expertise, finds value and inspiration.

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?
Start with fundamentals through hands-on practice, engage with the community through forums and meetups, and contribute to projects. Expand your knowledge through tutorials and start building your own projects. Have a mentor and network with professionals specializing in areas of interest.

How do you see the use of open source technologies evolving over the next five years?
In the next five years, open-source technologies are set to play a pivotal role in innovation, with a growing preference among developers and organizations to initiate their projects or migrate from commercial to open-source solutions. The community-driven nature of these technologies will fuel the addition of new features, enhancing their value and appeal.

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.

Peter Celentano is a Senior Specialist Solutions Architect, specializing in RDS PostgreSQL and Aurora PostgreSQL. Collaborating with AWS clients, he crafts scalable, secure, performant, and resilient cloud-based database architectures.

Peter will present "PostgreSQL Architecture Considerations for Application Developers". Read what Peter 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?
So much content in the PostgreSQL sphere focuses on the DBA best practices and how-to's, but not much exists by comparison for the database developer. In my talk, we'll discuss key PostgreSQL concepts and database architecture (and why app developers should care). I hope folks that attend my talk take away lessons learned from the field and some best practices which they may not be aware of yet.

What is your favorite aspect of Postgres Conference?
Meeting community experts and customers whom I've met virtually (but not yet in person).

What advice would you have for a Computer Science graduate or entry-level developer who is interested in learning and engaging with Postgres and other open source technologies?
The documentation for PostgreSQL is excellent (by comparison to many other open source projects). Spin up an ec2 instance, install PostgreSQL, and start figuring out how it works! You'll always learn more by breaking something and figuring out how to fix it then by reading about it in a book! Don't forget to vacuum!!

How do you see the use of open source technologies evolving over the next five years?
I see the development of better open source LLMs and hardware to back them. And eventually, deeper integration with GenAI in the Postgres core.

What considerations should be taken for the adoption and use of Postgres and related open source technologies?
Streamlining the patch review/approval process, allowing for faster innovation in Postgres core (without compromising on security and stability)

Check out the full schedule for PostgresConf US 2024. Learn more about our conference here!

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.

Bryn Llewellyn is a Technical Product Manager at Yugabyte, Inc., which offers an open source, cloud native distributed SQL database that looks like PostgreSQL to the developer. Bryn’s speciality is SQL and stored procedures in the context of distributed SQL.

Bryn has worked in the software field for more than forty years. He started working with SQL when he joined Oracle UK in 1990. He relocated to Oracle HQ (Redwood Shores, CA) in 1996 and his last role, before leaving, was as the Product Manager for PL/SQL. He left Oracle in April 2019 to join YugaByte, Inc.

Bryn started off doing image analysis and pattern recognition at Oxford University (programming in FORTRAN) and then worked in Oslo, first at the Norwegian Computing Center and then in a startup. In Norway, Bryn programmed in Simula—recognized as the first object-oriented programming language and as the inspiration for C++.

Bryn will be presenting a mini-tutorial on Friday, April 21st at 9:30am Pacific Time on "How to configure a PostgreSQL cluster for multitenancy." Read what he has to say about Postgres and why to attend his session:

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

I work for Yugabyte, Inc. (Learn more about Bryn's background). YugabyteDB uses the PostgreSQL query processing code “as is” on top of its own open source Spanner-like distributed storage system. I started at Yugabyte four years ago. And that’s when I first started to learn and to use PostgreSQL. My job is to document YugabyteDB’s SQL and PL/pgSQL functionality. This, by construction, has the same syntax and semantics as does vanilla PostgreSQL. I therefore ask lots of questions on the “pgsql-general” mailing list and, very occasionally, discover bugs in vanilla PostgreSQL.

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

Actually it’s a feature that’s new in Version 14: the new syntax for “language sql” functions that lets you define the body without making it a text literal so that it’s parsed at “create” time—allowing proper dependency tracking (and other benefits).

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

I would dearly like to see new functionality for "language plpgsql" subprograms that’s comparable to PL/SQL’s “package” construct (in Oracle Database).

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

I describe a practical solution to a genuine problem. And I make all the code easily available for download from the GitHub repo.

What is your favorite aspect of Postgres Conference?

Meeting real PostgreSQL practitioners and talking with them about their real-world use cases.

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

Get a job where you use the technology on a daily basis.

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

Our Yugabyte blog!

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

How YugabyteDB has made the familiar PostgreSQL functionality available as an open source, cloud native, massively scalable and fault tolerant, distributed SQL database system. (Of course, I would say this!) 

Anything else to add?

I’m excited to be attending (again), and speaking (again) at the Postgres Conference Silicon Valley.

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