Automatic Index Recommendations in PostgreSQL using pg_qualstats and hypopg
In my previous blog post, we have seen how the extension
Read more 22 Jul 2019
21 Jun 2019
Hypothetical Indexes in PostgreSQL
At recent conferences, we have received a curious question from users who have used Oracle in the past and are now using PostgreSQL: “Do we have hypothetical indexes in PostgreSQL ?“. The answer to that question is
Read more 14 Jun 2019
Bloom Indexes in PostgreSQL
There is a wide variety of indexes available in PostgreSQL. While most are common in almost all databases, there are some types of indexes that are more specific to PostgreSQL. For example, GIN indexes are helpful to speed up the search for element values within documents. GIN and GiST indexes could both be used […]
Read more 24 May 2019
An Overview of Sharding in PostgreSQL and How it Relates to MongoDB’s
A couple of weeks ago I presented at Percona University São Paulo about the new features in PostgreSQL that allow the deployment of simple shards. I’ve tried to summarize the main points in this post, as well as providing an introductory overview of sharding itself. Please note I haven’t included any third-party extensions that […]
Read more 13 May 2019
PostgreSQL Minor Versions Released May 9, 2019
Usually, the PostgreSQL Community releases minor patches on the Thursday of the second week of the second month of each quarter. This can vary depending on the nature of the fixes. For example, if the fixes include critical fixes as a postgres community response to security vulnerabilities or bugs that might affect data integrity. […]
Read more