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 Postgres Conference 2024, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Relevant Logic President/CEO Guyren Howe is a web developer, trainer, database expert, technical writer, and more specializing in PostgreSQL, Flutter, and Rails. Guyren will present “Postgres’s Type System” at Postgres Conference 2024. Read what Guyren has to say about Postgres and why to attend his session:

Why should attendees come to your talk at Postgres Conference 2024?

What would you like for them to take away from your session? Learn the important details of Postgres's type system: the built-in types, extension types, domains, arrays and custom types.

What is your favorite aspect of Postgres Conference?

My talk :)

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?

Follow the pgsql-general list. Learn relational theory. Don't listen to the database haters.

How do you see the use of open source technologies evolving over the next five years?

I foresee an open source boom as AI technologies can work with open source much better than closed.

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.

NEXTGRES founder Jonah Harris is a developer with expertise in database internals, high-performance systems, and near-real-time machine learning optimizations. Recognized for contributions to Oracle Database and PostgreSQL, with leadership roles at MariaDB, The Meet Group, and EnterpriseDB.

Jonah Harris will present The Future of MySQL is Postgres.  Read what Jonah 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?

Attendees will leave this session understanding how PostgreSQL offers superior performance, reliability, and a richer set of features for modern application development over MySQL, and how this extension simplifies and accelerates the migration process, ensuring transparent compatibility. 

What is your favorite aspect of Postgres Conference?

My favorite aspect of Postgres conferences is the collaborative spirit, where developers, administrators, and enthusiasts come together to share their knowledge and solve real-world challenges.

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?

I advise diving into hands-on projects and contributing to the OSS communities with an open mind; this offers invaluable experience and broad networking opportunities within open source communities, specifically PostgreSQL.

How do you see the use of open source technologies evolving over the next five years?

I see open source technologies becoming even more integral to innovation, driving collaboration and accessibility in emerging fields as well as traditional industries.

What considerations should be taken for the adoption and use of Postgres and related open source technologies? 

I always consider matching a technology's strengths to a project's needs. Whether it's Postgres or another OSS technology, evaluate it for its full capabilities and best fit first. Once those capabilities and fit are evaluated, assess the organization's ability to manage it.

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

Pavan Deolasse is a PostgreSQL consultant for 2ndQuadrant, one of our Platinum Sponsors for PostgresConf US 2018. Learn more about Pavan in this Community Profile:

Pavan Deolasee is a contributor to the development of PostgreSQL and related technologies. He holds a Masters of Technology in Computer Science from the Indian Institute of Technology, Bombay, and has several publications to his credit.

Pavan was introduced to PostgreSQL in the year 2006 when he started working for a PostgreSQL company. Hacking PostgreSQL was a completely new experience, but by accepting help from the community -- especially Simon Riggs, his mentor -- he began working through the code and was soon working on a very important project (Heap-Only-Tuple aka HOT). It was a very complicated piece of work, yet one of the landmark features in PostgreSQL and to this day remains one of his most important contributions to the project. Pavan has since contributed several patches to PostgreSQL. 

HOT was committed to PostgreSQL in 2008 and Pavan has continued to stay fully engaged with the project. In 2009/2010, alongside other colleagues, Pavan started work on Postgres-XC, a distributed, shared-nothing, clustering solution based on PostgreSQL. He was involved in designing the high-level architecture of the solution, and later wrote many important pieces of the code such as the GTM, the GTM Proxy, the 2PC transaction controller at the coordinator, changes required to guarantee global consistency of the data, and many distributed planner and executor pieces.

When Postgres-XL, a fork of Postgres-XC, was released to the public in 2014, Pavan once again became involved with the project and has been leading the development of Postgres-XL ever since. 

Pavan joined 2ndQuadrant not long after in April 2015, and once again started working with long time colleagues and friends; he and 2ndQuadrant have continued to actively work on the development of Postgres-XL. The focus area of development has been stability and performance of the product while keeping the fork as close to open source PostgreSQL as possible. The most recent release (Postgres-XL 10) supports intra-datanode query parallelism, thus taking distributed query processing to the next level.

In 2013, Pavan and two of his colleagues started the India PostgreSQL User Group. They started conducting small meet-ups, in order to promote the technology in India and bring the local community together. These small gatherings have now expanded with a membership of over 600 members, and into a full scale conference: PGConf India, Asia's largest PostgreSQL conference with more than 250 people in attendance each day in 2018. 

As part of the 2ndQuadrant team of PostgreSQL developers, Pavan continues to work on many interesting new features. He is an active part of the production support team and also has the opportunity to investigate interesting customer problems, often leading to important and critical bug fixes to the open source project.

Pavan had this to say about his involvement with the project:

“I love PostgreSQL and the PostgreSQL community, so you will continue to see me around.”

Call for Speakers: Join Us at Postgres Conference Seattle 2024!

We are excited to announce that the Postgres Conference Seattle 2024 is accepting speaker submissions! This is your chance to share your knowledge, insights, and experiences with the global PostgreSQL community in one of the world’s most innovative tech hubs. Whether you're a seasoned PostgreSQL expert or have unique insights on emerging trends, this is the perfect stage to amplify your voice and make an impact.

Why Speak at Postgres Conference: Seattle

As the largest PostgreSQL gathering in the U.S., Postgres Conference: Seattle 2024 brings together users, developers, DBAs, and thought leaders from diverse industries including FinTech, HealthTech, EdTech, and more! Here’s why you should consider submitting a proposal:

1. Expand Your Reach: Presenting at the conference will allow you to connect with hundreds of like-minded professionals, influencers, and companies shaping the future of data management.
2. Share Your Expertise: Whether you're a PostgreSQL guru or a curious learner with unique insights, your contribution can help others grow in their own Postgres journey.
3. Professional Recognition: Gain visibility and recognition within the Postgres community and broader tech industry. Being a speaker enhances your profile and can open doors for future collaborations, partnerships, or even job opportunities.
4. Contribute to the PostgreSQL Ecosystem: PostgreSQL continues to evolve rapidly. By sharing your experiences, you contribute to the collective growth and innovation of this incredible open-source database system.

Tracks for Every Interest

We’re looking for speakers across various areas of expertise. If you work in development, operations, or the essential aspects of PostgreSQL usage, we want to hear from you! Here’s a quick overview of our three main tracks:

Development (Dev) Track

Do you have cutting-edge insights on PostgreSQL development? This track is for talks focused on building, optimizing, and scaling applications using PostgreSQL. Some of the topics you could cover include:

• Query optimization and performance tuning
• Building and deploying PostgreSQL-based applications
• Best practices in database schema design
• Case studies of innovative solutions using PostgreSQL

Whether you're diving into PL/pgSQL, extending Postgres with custom functions, or exploring advanced indexing techniques, this is the perfect platform to share your expertise with fellow developers.

Operations (Ops) Track

If you’re working behind the scenes, ensuring that PostgreSQL environments are secure, scalable, and high-performing, the Ops track is for you. This track seeks submissions from database administrators, SREs, DevOps engineers, and anyone involved in the operational side of PostgreSQL, such as:

• Scaling PostgreSQL for high-traffic applications
• Backup and recovery strategies
• Monitoring and observability tools
• Managing multi-region or cloud-based Postgres instances

Share your experience on how to keep PostgreSQL running smoothly, even under the most demanding conditions.

Essentials Track

The Essentials track is perfect for those who want to speak about the core foundational aspects of PostgreSQL. It’s an ideal opportunity to present content geared toward people who are new to PostgreSQL or seeking to deepen their understanding of its key concepts. Suggested topics might include:

• Introduction to PostgreSQL for beginners
• SQL best practices and optimization
• Setting up a robust PostgreSQL environment
• Security fundamentals for database management

This track encourages first-time speakers and practitioners who want to help others navigate the essentials of working with PostgreSQL.

How to Submit Your Proposal

Submitting a proposal is easy! Simply prepare an abstract that describes your talk, its relevance to the conference tracks, and what attendees will take away from it. We encourage submissions from individuals of all backgrounds and levels of experience. Diversity of thought and experience enriches the conversation, and we welcome fresh perspectives.

Create a user account and submit your abstract, title, and description for review consideration.

Take this opportunity to shine as a thought leader in the Postgres world. Share your journey, inspire innovation, and connect with a vibrant community that’s as passionate about Postgres as you are. Submit your proposal today and join us in Seattle for an unforgettable experience!

Important Dates:

Submission Deadline: Monday, September 30th, midnight Pacific Time/ 3 am ET

Event Dates: November 6 - 7, 2024

Ready to Submit?

To submit your proposal and find more details, head to our submission page. Questions can be directed to organizers@postgresconf.org. We look forward to seeing you in Seattle!

We can’t wait to hear from you. Let’s shape the future of Postgres together!

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 Tatiana Krupenya, CEO of DBeaver. DBeaver provides a GUI interface that "connects to all data sources and stores, enables special extensions for big data databases, and includes supplemental features like a data viewer, an editor, mock data generator, metadata browsing and visual query builders, enabling users to dynamically access all of their databases while working within one environment."

Tatiana will present "Let robots help with queries" at this year's conference. Read more about Tatiana below:

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

DBeaver is one of the most popular UI tools for Postgres administration and data management. We support not only PostgreSQL itself but all popular forks and Postgres-based data sources, like Greenplum, Yugabyte, Redshift and others.

Why should attendees come to your talk at Postgres Conference Silicon Valley 2023? What would you like for them to take away from your session?

We have gotten used to thinking that working with databases is for database administrators and developers. However, thanks to modern technologies, people from other professional areas can also do this. It's data engineers, data architects, financial analysts, machine learning specialists, and others. The only thing that we need is to provide them with a safe and convenient infrastructure. In my talk, I would like to show how OpenAI can help with that.

What is your favorite aspect of Postgres Conference?

The best thing is the atmosphere. You can meet interesting people, learn about cutting-edge technologies, find new partners, and all of these in a friendly and positive environment.

Check out the full schedule for Postgres Conference Silicon Valley 2023. Walk-up registration is still available. Learn more here!

Postgres Conference Orlando 2025 was a success, thanks in no small part to the incredible support of our sponsors and partners. These organizations not only helped make the event possible, but they’re also dedicated champions of the Postgres community. We’re truly grateful for their participation.

We’d like to give a special shout-out to each of our Orlando sponsors and partners. Every one of them plays a unique and important role in the Postgres ecosystem. We encourage our community to learn more about the work they do:

Our Conference Sponsors:

Amazon Web Services (AWS):
AWS delivers fully managed, PostgreSQL-compatible database services. These services help organizations run secure, scalable, and high-performing workloads in the cloud. Their continued support of the open source ecosystem empowers developers and users around the world.

Google Cloud:
Google Cloud offers powerful, fully managed PostgreSQL solutions through Cloud SQL and AlloyDB. With a focus on scalability, performance, and integrated AI capabilities, Google empowers teams to build modern applications backed by enterprise-grade Postgres.

Our Conference Partners:

Command Prompt, Inc:
Command Prompt is one of the oldest PostgreSQL service providers. They offer consulting, managed services, and training for mission-critical environments. Their deep experience and ongoing advocacy have made them a trusted pillar of the Postgres community.

Fujitsu:
Fujitsu is a global technology leader that provides enterprise-grade PostgreSQL solutions backed by robust support. Their long-term contributions to PostgreSQL development show their commitment to open source and scalable, high-performance deployments.

PgEdge:
PgEdge makes globally distributed PostgreSQL possible with a platform designed for edge and multi-region deployments. By bringing data closer to users, they enhance performance, resilience, and compliance for modern applications.

Quest:
Quest offers proven tools for PostgreSQL monitoring, management, and performance optimization. Their solutions help teams simplify operations, boost efficiency, and manage complex database environments with confidence.

Tacnode:
Tacnode helps organizations power AI and analytics workflows with PostgreSQL at the core. By integrating data platforms and pipelines, they enable smarter and faster data applications across industries.

Redgate:
Redgate is a long-time leader in database tooling and now brings its expertise to PostgreSQL. Their tools, focused on DevOps, automation, and version control, help teams collaborate and deliver changes with speed and safety.

Unlimited with Exceptions:
Unlimited with Exceptions offers integrative health and wellness coaching focused on the whole person, including mind, body, and spirit. Through personalized guidance, they help individuals achieve balance, resilience, and sustainable well-being in daily life.

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.

Baji Shaik is a Sr. Lead Consultant at AWS ProServe, GCC AMER, and is a seasoned expert in SQL/NoSQL databases, specializing in database migration and optimization. With a wealth of experience spanning various technologies, he's authored multiple books on PostgreSQL and actively contributes to the AWS blog community.

Baji will present “Beyond Boundaries: Mastering 2-Level Encryption Migration in PostgreSQL”. Read what Baji has to say about Postgres and why to attend his session:

Why should attendees come to your talk at Postgres Conference 2024? What would you like for them to take away from your session?
Learn about encryption in Oracle, its pros and cons. Discover PostgreSQL's encryption methods. Choose and migrate to the right encryption method without compromising security or performance.

What is your favorite aspect of Postgres Conference?
I actively participate in PostgreSQL Conferences to expand my knowledge base and forge valuable connections within the community.

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?
My advice would be to start by exploring online resources, joining community forums, and actively participating in relevant conferences and workshops to gain practical experience and network with industry professionals.

How do you see the use of open source technologies evolving over the next five years?
I envision open-source technologies playing an increasingly vital role across various industries, driving innovation, collaboration, and cost-efficiency while fostering a more inclusive and accessible digital ecosystem.

What considerations should be taken for the adoption and use of Postgres and related open source technologies?
Considerations for adopting and using Postgres and related open-source technologies include evaluating compatibility with existing systems, assessing scalability and performance requirements, ensuring adequate support and expertise, and considering factors like security, community support, and long-term sustainability.

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 US 2018, learn more about the engaging content and our speakers for this year in our Speaker Spotlight Series.

Malcolm McLean of Apace Systems is a PostgreSQL DBA, Linux admin, Java/PHP developer and according to his bio "a bit of a pedantic perfectionist", with over 12 years of experience with PostgreSQL and somewhat more than that with Linux and development.

Malcolm is presenting "PostgreSQL in a Geographically Distributed Realtime Transactional System" on Thursday, April 19, at 11:20 am. Read what he has to say about Postgres and why to attend his session: 

Why PostgreSQL?

My very first job over 13 years ago introduced me to Postgres after having only worked with MySQL at university. Since then, I've been happier with its performance compared to other DB's I've benchmarked as well as with the features that are continuously introduced to keep the database on the forefront. Across 3 companies I have never looked back and never regretted my decision to always use Postgres.

Tell us about your involvement with the greater Postgres community.

I spoke at the first PgConf South Africa last year and I'm now one of the organisers of PostgresConf South Africa 2018.

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

Definitely the integrated logical replication without the need of an extension.

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

It perhaps won't make Postgres 11, but at least by Postgres 12 we should have BDR integrated with the current logical replication capabilities rounded off.

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

We had an interesting replication problem to solve. Multi-master replication where data needed to be replicated betweens servers in multiple countries, some with data restrictions, but without replicating data where it didn't need to go. So a sort of conditional sharding with redundancy in each data center.

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

 The talks on replication (anything to make our lives easier) and security. 

What is your favorite aspect of PostgresConf US?

Meeting like-minded people from different backgrounds. And of course, the trip itself. I've done quite a bit of travelling over the years, but I haven't yet been to the US.

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

Push yourself to learn. Sitting back doesn't get you very far. 

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

In support of our theme of "People, Postgres, Data", the Postgres Conference 2019 hosts its 3rd Annual Talent Exchange & Career Fair on Friday, March 22, from 11am - 2pm, in the Metropolitan Ballroom at the Sheraton New York Times Square. Featuring hiring managers and recruiters from several of our Postgres Conference sponsor companies, this event is free for job seekers and open to the public.

Companies represented include:

• 2nd Quadrant
• Amazon
• Credativ
• Cybertec
• DataDog
• DBeaver
• Google
• HighGo
• Microsoft
• Percona
• Pivotal
• TimeScaleDB (440 Labs)

With PostgreSQL winning the title of DBMS of the Year for the second year in a row from DB-Engines, talent with PostgreSQL related skills is in high demand. The Career Fair brings together employers and candidates in one of the hottest career options available today -- Postgres developers and DBAs -- as well as Solution Engineers, Customer Success Managers, Developer Advocates, Global Migration Practice Consultant, and many more!

We will also have Postgres professionals of varied backgrounds volunteering as career mentors from 11 am - 1:30 pm. Be sure to bring copies of your resume to share with employers and for feedback from our mentors.

New for this year -- Stop by the Postgres Conference 2019 Photo Booth on Friday between 11 am – 1pm for a free professional headshot! A professional image can often be a first impression for a hiring manager or recruiter and help you stand out amongst other job applicants.

Looking to increase your Postgres related knowledge and skills? Check out the full schedule for PostgresConf US 2019, and buy your tickets soon!