PostgreSQL underused features - WAL compression
WAL compression is a new feature of PostgreSQL 9.5 that not many are yet aware of. This post provides a test case highlighting the benefits.
Estimating table bloat in PostgreSQL
A short how to on quickly spotting bloated PostgreSQL tables - 2 different methods. We also show how to artificially generate table bloat.
UNIX sockets vs. localhost: PostgreSQL Performance advice
Unix sockets vs. localhost: We posted a lot of tuning advice on this blog already. Now we thought we would […]
VirtualBox vs. hardware for PostgreSQL
Is there really a performance difference in PostgreSQL on hardware and PostgreSQL on Virtualbox? Find out here.
Join pruning - Cool stuff in PostgreSQL
UPDATED 2023: Find out how the PostgreSQL optimizer decides about “join pruning”. Improve performance, provide end users with simpler plans.
Indexing Wikipedia with PostgreSQL | The goal is to see which settings are most suitable for the creation of a GIN index.
pg_stat_statements: The way I like it
Finding slow queries using the PostgreSQL extension pg_stat_statements. Improve your database performance and monitoring.
pgstrom: PostgreSQL on a GPU with joins
Test of performance using pgstrom with joins in PostgreSQL. Find out how pgstrom performs under different join conditions.
pgstrom: Checking GPU performance
A more extensive look at pgstrom (a module to make use of GPUs for PostgreSQL). I was excited to see the first real performance data.
Testing GPU-accelerated PostgreSQL
Some important work is also going into the PGStrom project, which is all about bringing the power of modern GPUs to PostgreSQL
