A short how to on quickly spotting bloated PostgreSQL tables - 2 different methods. We also show how to artificially generate table bloat.
How to use the watch command: allows you to watch the program output change over time. It is therefore a perfect tool to track down errors.
Unix sockets vs. localhost: We posted a lot of tuning advice on this blog already. Now we thought we would […]
How to beat the latency of Uber's geo-fencing query by just using nice PostgreSQL code and 30 minutes of programming time.
Here is some pg_type related trickery, which might be entertaining. A workaround for porting the pg_type table from Oracle to PostgreSQL.
If you happen to run Windows, pg_ctl provides a nice way to register a PostgreSQL service. We show you how to do it right.
Is there really a performance difference in PostgreSQL on hardware and PostgreSQL on Virtualbox? Find out here.
Configure services in a config file: pg_service.conf, and address them without having to worry about host, port, user and so on.
Learn how to use the INHERIT keyword in PostgreSQL, which allows a role to inherit permissions from another role. There is a catch, however.
UPDATED 2023: Find out how the PostgreSQL optimizer decides about “join pruning”. Improve performance, provide end users with simpler plans.
By coincidence I noticed that psql can produce perfect LaTeX code. How cool is that? We show you how to do it, with examples.
How to group PostgreSQL data with some dirty SQL trickery. Find the difference between timestamps; how to use flexible grouping.
