The PostgreSQL permission machinery is a pretty powerful thing. It allows people to come up with wonderful permission systems. In addition to that it is still reasonably simple to use. However, there are always some corner cases, which are often forgotten or simple not discovered by end users. INHERIT: Cool stuff In PostgreSQL a role […]

The PostgreSQL optimizer is really a wonderful piece of software, which is capable of doing great things. One of those great things is so called “join pruning”. In case PostgreSQL is able to detect a join which is actually not needed for execution, it will automatically remove it from the plan. Removing joins from the […]

I think I have touched my first PostgreSQL in 1998 or 1999. It has been a long time, but PostgreSQL keeps inspiring me. And still: I keep finding cool features, which have most likely been around for 15 years or more. By coincidence I noticed that psql can produce perfect LaTeX code. How cool is […]