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.
Indexing Wikipedia with PostgreSQL | The goal is to see which settings are most suitable for the creation of a GIN index.
Finding slow queries using the PostgreSQL extension pg_stat_statements. Improve your database performance and monitoring.
