Speeding up “min” and “max”
In this blog you can read why indexes are a great tool. And how it is possible speeding up a query many times by avoiding a sequential scans,
Reporting: Creating correct output
Creating reports is a core task of every PostgreSQL database engineer or developer. Learn to create reports properly.
Table bloat revisited: Making tables shrink in PostgreSQL
UPDATED Understand table bloat. Why deleting data from a table in a PostgreSQL database does not always shrink files on disk.
Detecting table bloat in PostgreSQL
If your PostgreSQL database is badly structured, you might face some table bloat. Figure out if a table is bloated or not.
Common mistakes: UNION vs. UNION ALL
In my role as a PostgreSQL consultant and trainer there are a couple of issues, which pop up on a […]
Reducing the number of columns with bit
How to reduce the number of columns using bitfields in PostgreSQL. "bit” can be used just as a normal char data type.
Time in PostgreSQL: Outer joins
UPDATED Aug 2023: How to use “generate_series” in an outer join: Use PostgreSQL to aggregate data on an hourly basis.
Time in PostgreSQL: The simple way
UPDATED Aug. 2023: How to process time in PostgreSQL: timeseries & generate_series, day constants, add and subtract from a time interval.
Transactional DDLs – a message to non-PostgreSQL users
In this blog we will talk about transactional DDL's in PostgreSQL vs other database systems. Find out more information.
Functions: The most widely ignored performance tweak
A PostgreSQL function performance can be marked as follows: VOLATILE, STABLE, IMMUTABLE or [NOT] LEAKPROOF. Undestand why.