Upcoming presentations
No upcoming presentations...
Past presentations
Power use of Indexes in PostgreSQL - A user perspective.
Understand the real use of each index types and the ways in which they can be utilized.
There have been many presentations about the Different Indexes in PostgreSQL ( B-Tree, HASH, GIN, GiST etc), especially from the architecture perspective. But these talks always lacked details from the user perspective on the selection of indexes.
It is common to see that architects and developers fail to select the right types of index and the way it should be used.
Just an overview of ...
Evolution of Partitioning Features in PostgreSQL - A super charged elephant
Important milestones in Partitioining features and how it evolved over a time to become one of the most powerful feature.
The Partitioning features in PostgreSQL is not something new. But it has matured over several years, release after release, especially the last 4 releases.
The evolutionary nature (small changes in each version) is often overlooked by users.
These small changes resulted in a build-up of a powerful Partitioning capability in PostgreSQL new versions. Now it is considered as capable of even...
Right execution plans can deliver maximum performance and throughput from your PostgreSQL database. It is important to understand all factors which affect the execution plan which includes costing, datatypes, indexing, filter and join conditions, pruning, runtime exclusions, etc. Poor understanding of the planner leads to suboptimal performance. There are substantial improvements in new vers...
Interesting 25 new features in PostgreSQL 12
Why PostgreSQL version 12 is the turning point and why enterprise customers should adopt it.
PostgreSQL 12 made a giant leap in many of the areas of PostgreSQL which includes partitioning, query planner, Indexing and some SQL features, etc. Among all of the interesting features for developers and admins, we shall be discussing 25 of the most interesting features with some good examples and benchmarks done This talk includes: - Partitioning improvements - Indexing Improvements 3. S...
Why PostgreSQL is Becoming a Migration Target in Large Enterprises
Reasons behind the rapid growth in adpoption and migration to PostgreSQL
This talk contains deeper analysis of compelling reasons why large enterprises opted to migrate to PostgreSQL. Every layer of enterprise, Executive management, Architects, Developers, and Operations team finds multiple strong reasons for selecting PostgreSQL. This is changing the PostgreSQL user-base and landscape. In other words, This talk is about why someone should migrate to PostgreSQL. T...
Deeper Understanding of PostgreSQL Execution Plan : At plan time and run time
smart planner in postgresql
Right execution plans can deliver maximum performance and throughput from your PostgreSQL database. It is important to understand all factors which affect the execution plan which includes costing, datatypes, indexing, filter and join conditions, pruning, runtime exclusions, etc. Poor understanding of the planner leads to suboptimal performance. There are substantial improvements in new version...