by Ibrar Ahmed | Mar 31, 2020 | PostgreSQL
PostgreSQL has a rich set of indexing functionality, and there are many articles explaining the syntax, usage, and value of the index. In this article, I will write basic and useful queries to see the state of database indexes. People develop databases and after some... by Ibrar Ahmed | Mar 5, 2020 | PostgreSQL
—Summary: This blog discusses the concept of NULL value in different programming languages and databases, with a focus on C/C++, Java, and PostgreSQL. The discussion includes how NULL is defined, how it works in different languages, and the various ways it can... by Ibrar Ahmed | Nov 20, 2019 | PostgreSQL
A global index, by very definition, is a single index on the parent table that maps to many underlying table partitions. The parent table itself does not have a single, unified underlying store so it must, therefore, retrieve the data satisfying index constraints from... by Ibrar Ahmed | Aug 15, 2019 | Benchmarks, PostgreSQL
by Ibrar Ahmed | Aug 2, 2019 | PostgreSQL
In a Linux world, whenever your database server crashes or gets terminated, you need to find its cause. There can be several reasons for this. It can be SIGSEGV, which is a crash due to some bug in the backend server, but this is the least likely reason. The most... by Ibrar Ahmed | Jul 30, 2019 | PostgreSQL
PostgreSQL is one of the finest object-relational databases, and its architecture is process-based instead of thread-based. While almost all the current database systems utilize threads for parallelism, PostgreSQL’s process-based architecture was implemented... by Ibrar Ahmed | Jul 1, 2019 | PostgreSQL
I want to thank everybody who attended my session “Deep Dive in PostgreSQL Indexes” in Austin. It was quite a wonderful experience! To cover a bigger audience, I also did a webinar on the same topic. There were many questions in that webinar, but... by Ibrar Ahmed | May 9, 2019 | Benchmarks, PostgreSQL
Every database management system is not optimized for every workload. Database systems are designed for specific loads, and thereby give better performance for that workload. Similarly, some kinds of queries work better on some database systems and worse on others.... by Ibrar Ahmed | May 1, 2019 | Benchmarks, MySQL, PostgreSQL
In this research, I wanted to see what kind of performance improvements could be gained by using a ClickHouse data source rather than PostgreSQL. Assuming that I would see performance advantages with using ClickHouse, would those advantages be retained if I... by Ibrar Ahmed | Apr 17, 2019 | PostgreSQL
PostgreSQL has a very unique way to review the code submitted by developers. Most open source software uses Github pull requests to accommodate users’ code. PostgreSQL has a Github page but doesn’t manage pull requests using Github. Many years ago,... by Ibrar Ahmed | Apr 5, 2019 | Insight for Developers, PostgreSQL
PostgreSQL is a powerful open source relational database management system. It extends the SQL language with additional features. A DBMS is not only defined by its performance and out of the box features, but also its ability to support bespoke/additional... by Ibrar Ahmed | Mar 29, 2019 | MySQL, PostgreSQL
Database management systems are meant to house data but, occasionally, they may need to talk with another DBMS. For example, to access an external server which may be hosting a different DBMS. With heterogeneous environments becoming more and more common, a bridge... by Ibrar Ahmed | Mar 6, 2019 | Benchmarks, PostgreSQL
The concept of Linux HugePages has existed for quite a while: for more than 10 years, introduced to Debian in 2007 with kernel version 2.6.23. Whilst a smaller page size is useful for general use, some memory intensive applications may gain performance by using bigger... by Ibrar Ahmed | Jan 3, 2019 | Insight for DBAs, Insight for Developers, PostgreSQL, Webinars
Please join Percona’s Senior Software Engineer, Ibrar Ahmed as he presents his High-Performance PostgreSQL, Tuning and Optimization Guide on Friday, January, 4th, at 8:00 AM PDT (UTC-7) / 11:00 AM EDT (UTC-4). View the Recording PostgreSQL is one of the leading... by Ibrar Ahmed | Dec 20, 2018 | Benchmarks, Open Source, PostgreSQL
Linux kernel provides a wide range of configuration options that can affect performance. It’s all about getting the right configuration for your application and workload. Just like any other database, PostgreSQL relies on the Linux kernel to be optimally... by Ibrar Ahmed | Oct 18, 2018 | Insight for DBAs, Insight for Developers, PostgreSQL
You may be aware that the new major version of PostgreSQL has been released today. PostgreSQL 11 is going to be one of the most vibrant releases in recent times. It incorporates many features found in proprietary, industry-leading database systems, further qualifying... by Ibrar Ahmed | Oct 12, 2018 | PostgreSQL, Security
Authorisations and encryption/decryption within a database system establish the basic guidelines in protecting your database by guarding against malicious structural or data changes. What are authorisations? Authorisations are the access privileges that mainly control... by Ibrar Ahmed | Aug 29, 2018 | Insight for DBAs, PostgreSQL
For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. Therefore, it is imperative that these parameters are...