In a recent wrestling match with the Linux “out-of-memory killer” for a CYBERTEC customer I got acquainted with Linux […]
CYBERTEC pgconfigurator: Configuring PostgreSQL visually
CYBERTEC pgconfigurator is the ideal tool to configure postgresql.conf visually. PostgreSQL configuration has never been easier.
Using "lightweight" functional indexes - BRIN
When it alters columns in queries, Postgres loses statistics, and it can cause slow queries. Fix it with BRIN functional indexes.
Best of PostgreSQL 10 for the DBA
PostgreSQL 10 was officially released! In this blog we took you to a tour and made an overview of the best features of PostgreSQL 10.
Speeding up the creation of Postgres replicas
What can be done when the PostgreSQL replication process is painfully slow for bigger databases? | Speeding up PostgreSQL replicas.
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 […]
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: 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
Next stop: Joining 1 million tables
This week I started my preparations for one of my talks in Madrid. The topic is: "Joining 1 million tables". […]
