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
DROP TABLE: Killing shared_buffers
UPDATED August 2023: How to tune shared buffers - when it is large, PostgreSQL performance issues may result: what to do to fix the problem.
PostgreSQL 9.4 aggregate filter clauses: They do pay off
In this blog ppost we cover the impact of aggregate FILTER clauses have on performance. Find out more about aggregation filters.
Forking databases - the art of copying without copying
I received a question about how to fork PostgreSQL databases like you can do on Heroku. As I did not […]
