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!

The month of January is just about over and we are coming up on the end of our Early Bird registration window for PostgresConf US 2018, which takes place in Jersey City, New Jersey from April 16th to April 20st at The Westin Jersey City Newport.

You have until tomorrow to purchase your tickets for $200 off for the largest PostgreSQL conference in the world. Early Bird tickets are on sale here through January 31.

We are excited to announce that we received over 170 proposals for PostgresConf US 2018, with an impressive range of high quality content and speakers. On April 16th and 17th, we are pleased to offer a choice of 15 different training sessions so you are sure to have the chance to dig deep into a topic that interests you. Some of our training classes are:

• Mastering PostgreSQL Administration
• Tutorial on Modern PostgreSQL High Availability
• Deep Dive into PostgreSQL Authentication Methods
• Digging into Advanced SQL
• The postgresql.conf from A-Z: Includes Postgres Performance and Maintenance

For a complete list, check out the events page for all of our training classes. 

Also during PostgresConf, you will also have an opportunity to meet our great sponsors, including:

• Diamond: Amazon Web Services, Pivotal
• Platinum: Compose, OpenSCG, 2ndQuadrant, Microsoft
• Gold: Cybertec, JetBrains, Citus Data, EnterpriseDB, Linode, Timescale, Cockroach Labs

At the Westin Jersey City Newport, we have negotiated a discounted conference room rate of $260/night + applicable taxes for attendees. Be sure to book prior to March 26, 2018 - the conference rate is not guaranteed after this date. Rooms may be booked via our dedicated Westin booking page, or via telephone (888) 627-7148. If booking via telephone please mention "PostgresConf US 2018" to receive the group rate.

For more information, please visit the PostgresConf US 2018 website. 

Stay tuned for our presentation and breakout sessions announcement. We look forward to seeing you in April!

P.S. Looking for a discount code? Check your local Postgres User Group mailing list.

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!

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.”

We are pleased to announce a partnership between Redgate and PgCentral Foundation, Inc., to return Postgres Conference to Seattle! We’ll be joining forces in their brand-new venue -- the Summit at the Seattle Convention Centre (SCC) -- during this year’s PASS Data Community Summit (PASS Summit).

The PASS Summit team has been working to create a more collaborative environment between professional data communities. The new venue for 2024 allows the perfect opportunity to host our People, Postgres, Data community for the Postgres Conference: Seattle 2024 on November 6 and 7.

About PASS Summit

The PASS Summit has earned its reputation as the premier event for data security and database professionals. Since Redgate took ownership in 2021, the event has continued to offer unmatched learning opportunities, covering a wide range of data platforms including SQL Server, PostgreSQL, AWS, Google Cloud, and more. This year’s summit will take place in Seattle, from November 4-8, 2024, welcoming thousands of attendees eager to sharpen their skills and stay on the cutting edge of data management.

PASS Summit is not just about lectures and sessions –  it offers hands-on learning experiences, a vibrant community space, and networking opportunities with industry leaders. The event is known for its comprehensive sessions, keynotes by industry experts, and access to the latest tools and technologies that empower organizations to manage their data effectively. Whether you're a beginner or a seasoned professional, there’s something for everyone.

For more details about the summit, visit the official website: PASS Data Community Summit 2024

Highlights from Postgres Conference Seattle 2024

Alongside PASS Summit, Postgres Conference: Seattle 2024 will also be taking place, making Seattle the hub of data learning in early November. Postgres Conference is the leading event dedicated to Postgres, an open-source database that has become essential for many modern organizations. This year’s event is powered by the joint efforts of Redgate and Command Prompt, Inc., and is priced at an affordable $599 through November 3rd.*

PostgresConf Seattle attendees will get exclusive access to certain elements of the PASS Data Community Summit, such as:

- PASS Summit Keynotes: Hear from influential figures shaping the future of data.

- PASS Ecosystem Sessions: Deep dives into data platforms and security.

- Community Zone: A space to collaborate with other professionals and expand your network.

- Exhibit Hall and Exhibitor Reception: Discover the latest tools and technologies from industry-leading vendors.

- Lunches, Refreshment Breaks, and Community Events: Plenty of opportunities to refuel and connect with peers.

This integration gives PostgreSQL enthusiasts a chance to engage in the broader data conversation while still enjoying tailored Postgres content.

Check out the event page here for more information on Postgres Conference Seattle 2024.

* Note: Postgres Conference: Seattle 2024 online registration closes November 3rd.  On-site registration will require the purchase of a PASS24 1-Day or 3-Day ticket, so don't delay!

The Postgres Conference 2025 is set to take place in Orlando, Florida, from March 18 to 21, 2025. This year's conference features an expanded lineup of tracks, including the Dev Track, which is tailored for developers seeking to deepen their expertise in PostgreSQL. This track offers sessions to enhance your development skills, explore new tools, and provide practical insights into PostgreSQL's capabilities.

What to Expect

The Dev Track is curated to address the diverse needs of developers working with PostgreSQL. Attendees can look forward to:

• In-Depth Tutorials: Hands-on sessions that delve into advanced PostgreSQL features and development practices.
• Expert-Led Workshops: Opportunities to learn from seasoned professionals about optimizing performance, implementing machine learning, and more.
• Cutting-Edge Topics: Discussions on the latest tools, extensions, and methodologies in the PostgreSQL ecosystem.

Session Highlights

Here are some standout sessions in the Dev Track:

• A Practical Guide to Set-Based Queries (paid training)

  • Speaker: Aaron Cutshall
  • Date & Time: March 18, 2025, 9:00 AM – 12:00 PM
  • Description: This workshop addresses performance issues arising from procedural code in PostgreSQL. Aaron will guide participants through transforming procedural logic into efficient set-based queries, enhancing database performance.
    
    

• Machine Learning using PostgreSQL (paid training)

  • Speaker: Abbas Butt
  • Date & Time: March 18, 2025, 1:00 PM – 4:00 PM
  • Description: Abbas will introduce participants to implementing machine learning algorithms directly within PostgreSQL 15.x using Apache MADlib 2.1.0 installed on Ubuntu 22.04. The session covers practical applications of predictive analytics, enabling developers to harness the power of ML in their databases.
    
    
• From MongoDB to Postgres: Building an Open Source Standard for Document Databases
  
  • Speaker: Peter Farkas
  • Date & Time: March 19, 2025, 4:00 - 4:20 PM
  • Description: This session reviews the current state of document databases, and demonstrates how Postgres handles MongoDB workloads with ease.

For a comprehensive view of all sessions and to plan your itinerary, visit the official conference schedule.

Why Attend?

Participating in the Dev Track at Postgres Conference 2025 offers numerous benefits:

• Skill Enhancement: Gain practical knowledge and hands-on experience with PostgreSQL's advanced features.
• Networking Opportunities: Connect with fellow developers, industry experts, and thought leaders.
• Stay Current: Keep abreast of the latest developments, tools, and best practices in the PostgreSQL community.

Don't miss this opportunity to elevate your PostgreSQL development skills. Register now and join us in Orlando for an enriching experience.

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.

We are thrilled to invite you to partner with us for Postgres Conference 2025, taking place in sunny Orlando, Florida, from March 18th to 21st! 

For 2025, we have expanded our conference offerings to provide even greater value to our attendees and partners. We’ve added an extra day dedicated to Professional Training, introduced a Professional Development track, and are excited to offer a unique Wellness Sponsorship that supports attendee well-being. 

Why Sponsor Postgres Conference 2025? Our conference is renowned for its diverse programming, including Talks, Keynotes, Conference Keynotes, Half Day and Full Day Trainings, Tutorials, and Presentations. Each session fits into one of five specialized tracks: Dev, Ops, Essentials, Professional Development, and Cloud. This variety creates extensive opportunities for you to engage directly with your target audience, whether they're developers, operators, or leaders focused on professional growth.

A partnership with Postgres Conference 2025 offers:

• Increased visibility within the PostgreSQL community
• Direct networking with key decision-makers and influencers
• Opportunities to showcase your brand through custom sponsorship packages

Whether you are interested in a general sponsorship or would like to discuss custom opportunities tailored to your brand, we would love to connect. Explore the best options for you on our Sponsorships page. 

If you would like to schedule a call or need further information, please don’t hesitate to reach out to 2025-sponsors@postgresconf.org. We look forward to discussing how we can make your sponsorship experience at Postgres Conference 2025 truly impactful.

Sincerely,

Postgres Conference 2025 Sponsorship Team

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

Meet Dave Stokes, Technology Evangelist for Percona. Dave Stokes is the author of MySQL & JSON - A Practical Programming Guide. He resides in Texas with the mandated pickup truck, hound dog, and guitars.

Read what Dave has to say about Postgres and why to attend his sessions which include "MERGE() - A Quick Introduction" and "PostgreSQL High Availability: The Considerations and the Candidates."

Why Postgres? Tell us about your involvement with the greater Postgres community. (How long have you been involved? How have you contributed? How else would you want to contribute?)

I have been mainly involved in the MySQL Community for a long time but am now exploring PostgreSQL. I have started a series on PostgreSQL for MySQL DBAs that is very popular

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

Merge()!

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

JSON_TABLE()!! Please, please, pretty please!!

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?

From the Merge() talk, I hope they will go away understanding how transaction log processing works. For the HA talk, I do not expect them to walk away as they will be so filled with brain energy that they sort of levitate away!

What is your favorite aspect of Postgres Conference?

The people.

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?

Open source !- free. It provides a flexibility to innovate.

What's your top suggested readings for 2023?

Anything by Tim Dorsey.

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

Open-source software has proven that good code comes from more than just semi-benevolent corporations. And PostgreSQL has proven the power of the mailing list!

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