PostgreSQL: GROUP BY expression
GROUP BY is an integral part of SQL and PostgreSQL. You might not know that the GROUP BY expression can handle more than just simple fields.
effective_cache_size: A practical example
Few people know what effective_cache_size really does in PostgreSQL. Let me share some more insights and a practical example.
PostgreSQL: More performance for LIKE and ILIKE statements
This blogpost shows what PostgreSQL can do to speed up LIKE and ILIKE to archieve better PostgreSQL database performance.
PostgreSQL: Useful new data types - CREATE DOMAIN
UPDATED 08.05.2023 How to create useful new data types with CREATE DOMAIN in PostgreSQL | Advanced server side check constraints
Calculating differences between rows in SQL
Calculating differences between rows | How can one calculate the difference between the current and the previous row? | timeseries data
PostgreSQL: ltree vs. WITH RECURSIVE
WITH RECURSIVE in PostgreSQL is efficient. However, ltree does have its strengths as well. Let us take a closer look. | Improve performance
SQL trickery: Hypothetical aggregates
“If we had this data what would it mean?” - read more about this PostgreSQL technique, what it is good for & how it works.
Composite type performance issues in PostgreSQL
Table functions & performance: Solve performance issues related to stored procedures and or a composite data type in PostgreSQL
PostgreSQL: Speeding up recursive queries and hierarchical data
How to use a hierarchical query, which is an SQL query that handles model data such as the structure of organizations - find out more
SQL trickery: Configuring window functions
How to use window functions and analytics - these have long been around in PostgreSQL and are widely used by advanced developers.
