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
Dr. Ibrar Ahmed has presented the following presentations
Scaling PostgreSQL: Horizontal vs. Vertical
at
Postgres Conference 2025
presented by Dr. Ibrar Ahmed
Scaling PostgreSQL is critical for handling larger workloads as your application grows. But what’s the best path: scale up or scale out? In this talk, we’ll explore both approaches, breaking down the tools, partitioning strategies, and performance considerations that make PostgreSQL shine in any scalability scenario. With insights tailored to PostgreSQL’s unique capabilities, you’ll walk away p...
more Wed 19 2025 Ops
Scaling PostgreSQL: Navigating Horizontal and Vertical Scalability Pathways
at
Postgres Conference 2024
Scaling PostgreSQL
presented by Dr. 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
Achieving High Availability (HA) in PostgreSQL: Strategies, Tools, and Best Practices
at
Postgres Conference 2024
High Availability
presented by Dr. 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
Unraveling Multi-Master Replication in PostgreSQL: Architectures and Solutions
at
Postgres Conference 2024
Multi-Master Replication
presented by Dr. 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
Unleash Ultra High Availability and Zero Downtime Maintenance with Distributed PostgreSQL
at
Postgres World Webinars 2023
pgEdge Multi-Master & Multi-Region
presented by Dr. 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
Tune PostgreSQL for Read/Write Scalability.
at
Silicon Valley 2022
presented by Dr. 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
A Deep Dive into PostgreSQL Indexing
at
Silicon Valley 2022
presented by Dr. 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
All about PostgreSQL Security
at
Postgres Webinar Series
presented by Dr. 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
Tune your Linux Box, not just PostgreSQL
at
CHINA 2020 And PGConf.Asia 2020
presented by Dr. 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
A Deep Dive into PostgreSQL Indexing
at
CHINA 2020 And PGConf.Asia 2020
presented by Dr. 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
All about PostgreSQL Security.
at
CHINA 2020 And PGConf.Asia 2020
presented by Dr. 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
A Deep Dive into PostgreSQL Indexing
at
Postgres Webinar Series
presented by Dr. 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
A Deep Dive into PostgreSQL Indexing
at
Postgres Webinar Series
presented by Dr. 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
A Deep Dive into PostgreSQL Indexing
at
Postgres Conference 2020
PostgreSQL Indexing
presented by Dr. 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
Joining Heterogeneous Databases is a reality, not a Myth
at
Postgres Conference 2020
PostgreSQL FDW
presented by Dr. 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...
Tune your Linux Box, not just PostgreSQL
at
Postgres Conference 2020
Linux Kernel Tuning for PostgreSQL
presented by Dr. 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
Tune your Linux Box, not just PostgreSQL
at
Beijing 2019
presented by Dr. 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
A Deep Dive into PostgreSQL Indexing
at
Beijing 2019
presented by Dr. 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
Join Heterogeneous Databases using PostgreSQL Foreign Data Wrappers
at
Beijing 2019
presented by Dr. 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
Join Heterogeneous Databases using PostgreSQL Foreign Data Wrappers
at
Postgres Conference
PostgreSQL FDW
presented by Dr. 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