PostgreSQL Vim integration: Finally ...
Importing into Vim is basically not too much of an issue – but, exporting data back to PostgreSQL is more of an issue.
From PostgreSQL directly to Vim
Some (obvious) ideas can struck you when you are just sitting around at the airport or so. This is exactly […]
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.
