PostgreSQL vs PostgreSQL vs Postgres vs Oracle vs all the rest
How can you find data even if there are typos? In PostgreSQL there are various solutions to the problem of a search with odd spelling.
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
