Ibrar Ahmed @@ibrar_ahmad

Principal Engineer at pgEdge

About

Ibrar Ahmed, Principal Engineer at pgEdge, brings 25 years of experience in software design and open-source development, particularly PostgreSQL. With a strong background in system-level embedded development, Ibrar has made impactful contributions during his tenure at companies like EnterpriseDB, Percona, and Bitnine. Since 2006, he's been instrumental in enhancing PostgreSQL's core engine, driving performance improvements, and refining essential modules.

His expertise spans MySQL, Oracle, and NoSQL solutions like MongoDB and Hadoop, alongside tools like Hive, HBase, and Spark. A prolific author and blogger, Ibrar shares deep insights into PostgreSQL with several authoritative books. Over the past year, he’s delivered over fifteen talks worldwide at PostgreSQL conferences, further cementing his reputation. His dedication to advancing data management technology continues to shape

Ibrar Ahmed has presented the following presentations

    Ibrar Ahmed Scaling PostgreSQL: Navigating Horizontal and Vertical Scalability Pathways at Postgres Conference 2024
    Scaling PostgreSQL

    presented by Ibrar Ahmed

    As businesses grow and data traffic intensifies, PostgreSQL database systems are often thrust into the spotlight, faced with the critical challenge of accommodating increasing workloads. In the database realm, scalability is the magic word. But how does one choose between vertical (scaling up) and horizontal (scaling out) scalability? And more importantly, how are these effectively implemented ...

    more

    Fri 19 2024 Ops
    Ibrar Ahmed Achieving High Availability (HA) in PostgreSQL: Strategies, Tools, and Best Practices at Postgres Conference 2024
    High Availability

    presented by Ibrar Ahmed

    In the continuously evolving landscape of digital enterprises, ensuring uninterrupted service and data availability is not just a luxury, but a mandate. PostgreSQL, celebrated for its robustness and flexibility, offers myriad ways to implement High Availability (HA) and fault tolerance. However, with options comes complexity. This talk aims to demystify HA for PostgreSQL, guiding attendees thro...

    more

    Wed 17 2024 Ops
    Ibrar Ahmed Unraveling Multi-Master Replication in PostgreSQL: Architectures and Solutions at Postgres Conference 2024
    Multi-Master Replication

    presented by Ibrar Ahmed

    Unraveling Multi-Master Replication in PostgreSQL: Architectures and Solutions

    Abstract: PostgreSQL, one of the world’s most advanced open-source relational database management systems, has undergone significant evolution over the years, with its vast ecosystem continuously expanding to meet the diverse needs of the modern digital age. One area that has captured significant attention is dat...

    more

    Thu 18 2024 Ops
    Ibrar Ahmed Mike Josephson Denis Lussier Unleash Ultra High Availability and Zero Downtime Maintenance with Distributed PostgreSQL at Postgres World Webinars 2023
    pgEdge Multi-Master & Multi-Region

    presented by Ibrar Ahmed, Mike Josephson, and Denis Lussier


    video

    Join us for an exclusive webinar where we dive into how organizations can ensure data availability and uptime, no matter the circumstances. Whether you're an IT manager, database administrator, or developer, this webinar will show you how to apply the power of distributed PostgreSQL to power applications that are always on and always available.

    In this webinar, we'll explore the techniques...

    more

    Thu 9 2023 Ops
    Ibrar Ahmed Tune PostgreSQL for Read/Write Scalability. at Silicon Valley 2022

    presented by Ibrar Ahmed

    PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. Nowadays, production systems have quite expensive machines, which require extra configuration for PostgreSQL. PostgreSQL provides extensive configuration parameters to configure it according to the available hardware. Sometimes it is hard to co...

    more

    Fri 8 2022 Dev
    Ibrar Ahmed A Deep Dive into PostgreSQL Indexing at Silicon Valley 2022

    presented by Ibrar Ahmed

    Indexes are a fundamental feature of relational databases, and PostgreSQL offers developers and designers a rich collection of options. To take advantage of these entirely, users need to understand the basic concept of indexes to compare the different index types and apply them to different application scenarios. Only then can you make an informed decision about your database index strategy an...

    more

    Fri 8 2022 Dev
    Ibrar Ahmed All about PostgreSQL Security at Postgres Webinar Series

    presented by Ibrar Ahmed


    video

    PostgreSQL provides different levels of security. This talk will cover all the available security techniques used in PostgreSQL 13. We’ll look at client-side security (LibPq, JDBC) through to server-side security. It will cover all supported authentication methods and the pros and cons of all these methods. Some of the key features of the talk are: - Introduction to Cryptography - SSL, TLS, GSS...

    more

    Thu 5 2020 Data
    Ibrar Ahmed Tune your Linux Box, not just PostgreSQL at CHINA 2020 And PGConf.Asia 2020

    presented by Ibrar Ahmed

    PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. The default configuration is designed in such a way that PostgreSQL can run on any system using minimum resources. Consequently, a default installation of PostgreSQL does not give optimum performance on the high-performance machine because it i...

    more

    Fri 20 2020 Performance
    Ibrar Ahmed A Deep Dive into PostgreSQL Indexing at CHINA 2020 And PGConf.Asia 2020

    presented by Ibrar Ahmed

    Indexes are a basic feature of relational databases, and PostgreSQL offers a rich collection of options to developers and designers. To take advantage of these fully, users need to understand the basic concept of indexes, to be able to compare the different index types and how they apply to different application scenarios. Only then can you make an informed decision about your database index...

    more

    Thu 19 2020 Performance
    Ibrar Ahmed All about PostgreSQL Security. at CHINA 2020 And PGConf.Asia 2020

    presented by Ibrar Ahmed

    PostgreSQL provides different levels of security. This talk will cover all the available security techniques used in PostgreSQL 13. We’ll look at client-side security (LibPq, JDBC) through to server-side security. It will cover all supported authentication methods and the pros and cons of all these methods. Some of the key features of the talk are: - Introduction to Cryptography - SSL, TLS, GSS...

    more

    Fri 20 2020 Security
    Ibrar Ahmed A Deep Dive into PostgreSQL Indexing at Postgres Webinar Series

    presented by Ibrar Ahmed


    video

    Indexes are a basic feature of relational databases, and PostgreSQL offers a rich collection of options to developers and designers. To take advantage of these fully, users need to understand the basic concept of indexes, to be able to compare the different index types and how they apply to different application scenarios. Only then can you make an informed decision about your database index st...

    more

    Tue 7 2020 Ops
    Ibrar Ahmed A Deep Dive into PostgreSQL Indexing at Postgres Webinar Series

    presented by Ibrar Ahmed


    video

    Indexes are a basic feature of relational databases, and PostgreSQL offers a rich collection of options to developers and designers. To take advantage of these fully, users need to understand the basic concept of indexes, to be able to compare the different index types and how they apply to different application scenarios. Only then can you make an informed decision about your database index...

    more

    Thu 21 2020 Ops
    Ibrar Ahmed A Deep Dive into PostgreSQL Indexing at Postgres Conference 2020
    PostgreSQL Indexing

    presented by Ibrar Ahmed

    Indexes are a basic feature of relational databases, and PostgreSQL offers a rich collection of options to developers and designers. To take advantage of these fully, users need to understand the basic concept of indexes, to be able to compare the different index types and how they apply to different application scenarios. Only then can you make an informed decision about your database index...

    more

    Development
    Ibrar Ahmed Joining Heterogeneous Databases is a reality, not a Myth at Postgres Conference 2020
    PostgreSQL FDW

    presented by Ibrar Ahmed

    Joining Heterogeneous Databases is a reality, not a Myth
    PostgreSQL provides a way to communicate with external data sources. This could be another PostgreSQL instance or any other database. The other database might be a relational database such as Clickhouse, MySQL or Oracle; or any NoSQL database such as MongoDB or Hadoop. To achieve this, PostgreSQL implements ISO Standard call SQL-MED in...

    more

    Development
    Ibrar Ahmed Tune your Linux Box, not just PostgreSQL at Postgres Conference 2020
    Linux Kernel Tuning for PostgreSQL

    presented by Ibrar Ahmed

    PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. The default configuration is designed in such a way that PostgreSQL can run on any system using minimum resources. Consequently, a default installation of PostgreSQL does not give optimum performance on the high-performance machine because it is ...

    more

    Ops and Administration
    Ibrar Ahmed Tune your Linux Box, not just PostgreSQL at Beijing 2019

    presented by Ibrar Ahmed

    PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. The default configuration is designed in such a way that PostgreSQL can run on any system using minimum resources. Consequently, a default installation of PostgreSQL does not give optimum performance on high-performance machine because it is set ...

    more

    Fri 5 2019 English Speaker Track
    Ibrar Ahmed A Deep Dive into PostgreSQL Indexing at Beijing 2019

    presented by Ibrar Ahmed

    Indexes are a basic feature of relational databases, and PostgreSQL offers a rich collection of options to developers and designers. To take advantage of these fully, users need to understand the basic concept of indexes, to be able to compare the different index types and how they apply to different application scenarios. Only then can you make an informed decision about your database index s...

    more

    Fri 5 2019 English Speaker Track
    Ibrar Ahmed Join Heterogeneous Databases using PostgreSQL Foreign Data Wrappers at Beijing 2019

    presented by Ibrar Ahmed

    PostgreSQL provides a way to communicate with external data sources. This could be another PostgreSQL instance or any other database. The other database might be a relational database such as Clickhouse, MySQL or Oracle; or any NoSQL database such as MongoDB or Hadoop. To achieve this, PostgreSQL implements ISO Standard call SQL-MED in the form of Foreign Data Wrappers (FDW). This presentation ...

    more

    Fri 5 2019 English Speaker Track
    Ibrar Ahmed Join Heterogeneous Databases using PostgreSQL Foreign Data Wrappers at Postgres Conference
    PostgreSQL FDW

    presented by Ibrar Ahmed

    PostgreSQL provides a way to communicate with external data sources. This could be another PostgreSQL instance or any other database. The other database might be a relational database such as MySQL or Oracle; or any NoSQL database such as MongoDB or Hadoop. To achieve this, PostgreSQL implements ISO Standard call SQL-MED in the form of Foreign Data Wrappers (FDW). This presentation will explain...

    more

    Thu 21 2019 Use Cases