Mydbops Rocks PGConf India 2024 with Lightning Talk on pg_osc

Mydbops
Mar 5, 2024
10
Mins to Read
All

Thriving PostgreSQL Community at PGConf India 2024

The energy at PGConf India 2024 was truly infectious! As your trusted PostgreSQL management partner, Mydbops was thrilled to be at the heart of this vibrant event. The conference offered a fantastic platform for the PostgreSQL community in India to connect, share knowledge, and explore the latest advancements in the database world. From insightful presentations to engaging workshops, PGConf India 2024 proved to be a valuable learning experience for all attendees.

Mydbops @ PGConf India 2024
Mydbops @ PGConf India 2024
Mydbops @ PGConf India 2024
Mydbops @ PGConf India 2024
Mydbops @ PGConf India 2024
Mydbops @ PGConf India 2024

Mydbops Takes Center Stage at PGConf India 2024

Mydbops actively participated in the conference by delivering a well-received lightning speech on pg_osc (pg-online-schema-change). We want to extend our sincere appreciation to the organizers for providing such a fantastic platform to share our knowledge.

Mydbops @ PGConf India 2024
Mydbops @ PGConf India 2024

Unveiling the Power of pg_osc

Mydbops Lightning Talk on PostgrSQL Schema Changes with pg_osc
Mydbops Lightning Talk on PostgrSQL Schema Changes with pg_osc

Aakash M from Mydbops presented on pg_osc, a game-changer for PostgreSQL schema changes, at PGConf India 2024. Our lightning speech focused on empowering fellow PostgreSQL enthusiasts with the magic of pg_osc. This innovative tool has revolutionized the way we approach schema modifications in PostgreSQL. Here's a quick summary:

What is pg_osc?

  • Tool for minimal downtime schema changes.
  • Similar to pt_osc (MySQL) and pg_repack.
Mydbops Lightning Talk on PostgrSQL Schema Changes with pg_osc
Mydbops Lightning Talk on PostgrSQL Schema Changes with pg_osc

Benefits

  • Reduced Downtime: Minimal locking during process.
  • Data Security: No data loss during schema changes.
  • Potential Bloat Reduction: Table rebuild during process.
Mydbops @ PGConf India 2024
Mydbops @ PGConf India 2024

How it Works (Simplified)

  1. Create an audit table to track changes.
  2. Create a shadow table with desired schema changes.
  3. Copy data and indexes to the shadow table.
  4. Replay changes from the audit table.
  5. Swap the primary and shadow tables (minimal downtime).

The audience's enthusiastic response to the talk highlighted the ever-growing importance of tools like pg_osc in simplifying database management tasks.

Mydbops Lightning Talk at PGConf India 2024 on PostgrSQL Schema Changes with pg_osc
PGConf India 2024
Mydbops Lightning Talk at PGConf India 2024 on PostgrSQL Schema Changes with pg_osc
Mydbops Lightning Talk at PGConf India 2024 on PostgrSQL Schema Changes with pg_osc

Mydbops: Your PostgreSQL Experts Beyond the Conference

Our participation in PGConf India 2024 was about more than just delivering a presentation. It was about connecting with the PostgreSQL community, sharing valuable knowledge, and showcasing our expertise. We are incredibly grateful to the organizers for their meticulous planning and execution, which made the conference such a resounding success.

Mydbops - Your Comprehensive PostgreSQL Partner

At Mydbops, we are passionate about PostgreSQL and go beyond just attending conferences. We offer a comprehensive range of PostgreSQL management services to empower businesses:

  • Performance Optimization: We help you fine-tune your PostgreSQL databases for peak performance, ensuring smooth operation and responsiveness.
  • Security Audits: Our security experts conduct thorough audits to identify and address potential vulnerabilities in your PostgreSQL deployments.
  • Replication Setup and Management: We assist you in setting up and managing robust PostgreSQL replication configurations for high availability and disaster recovery.
  • Migration Assistance: Need to migrate to PostgreSQL? We provide seamless migration services to ensure a smooth transition.

Join the Mydbops PostgreSQL Community!

Whether you're a seasoned PostgreSQL administrator or just starting your journey, Mydbops is here to support you. We actively participate in industry events like PGConf India to share knowledge and foster connections.

Let's talk PostgreSQL! Contact Mydbops today to discuss how we can leverage pg_osc and our PostgreSQL expertise to optimize your database management practices. We're here to help you unlock the full potential of your PostgreSQL databases!

{{cta}}

No items found.

About the Author

Mydbops

Subscribe Now!

Subscribe here to get exclusive updates on upcoming webinars, meetups, and to receive instant updates on new database technologies.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.