Inheritance - One more reason to love PostgreSQL
The PostgreSQL feature "inheritance" works like a charm. You ask why? Well, here are the details we really like about it.
PostgreSQL exclusion constraints: Beyond UNIQUE
UPDATED AUGUST 2023: A couple of years ago, PostgreSQL introduced so called “exclusion constraints”, which are defined with the EXCLUDE […]
BRIN indexes: Correlation, correlation, correlation
BRIN indexes have been introduced in PostgreSQL 9.5. While BRIN indexes are definitely a win, people tend to exaggerate and use them far too frequently.
Watch command - how to watch a PostgreSQL database
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.
Beating Uber with a PostgreSQL prototype
How to beat the latency of Uber's geo-fencing query by just using nice PostgreSQL code and 30 minutes of programming time.
Migrating from Oracle: One word about pg_type
Here is some pg_type related trickery, which might be entertaining. A workaround for porting the pg_type table from Oracle to PostgreSQL.
Registering PostgreSQL as a service on Windows with pg_ctl
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.
pg_service.conf: The forgotten config file
Configure services in a config file: pg_service.conf, and address them without having to worry about host, port, user and so on.
Permissions: A little trickery
Learn how to use the INHERIT keyword in PostgreSQL, which allows a role to inherit permissions from another role. There is a catch, however.
By coincidence I noticed that psql can produce perfect LaTeX code. How cool is that? We show you how to do it, with examples.