I’ve become the licensed driverFinally, I’ve graduated from the driving school and got my driver license :)Oct 13, 2024Oct 13, 2024
What are merge join, hash join, and nested loop? Example in PostgreSQL.Introduction.Sep 17, 2024Sep 17, 2024
Measures and dimensions in DWH. Preparing a star schema model in PostgreSQL.Below it’s provided the SQL code example (SQL DDL and the PL/pgSQL function for data seeding). It demonstrates the construction of a…Aug 18, 2024Aug 18, 2024
What is a bitmap scan in PostgreSQL?Bitmap scan is one of the methods for data retrieval in PostgreSQL, consisting of two main types of nodes, that can be seen when dumping…Aug 2, 2024Aug 2, 2024
What is work_mem and what is this parameter used for in PostgreSQL?“work_mem” is an important configuration parameter in PostgreSQL, that defines the limit, i.e., the maximum amount of memory (if not…Jun 16, 2024Jun 16, 2024
