Trying out Postgres Bloom indexes
Let's set up a simple demo to exemplify “fields of application” for Bloom and to also gauge pros/cons/performance in comparison to B-tree.
So what are Bloom indexes for Postgres?
Overview of the Bloom index in PostgreSQL. It's a very useful index method - find out how to use it & how it affects performance.
writer and wal writer PostgreSQL processes explained
Why are there 2 similarly-named processes called writer and WAL writer? What do they do? Get an explanation.
Exposing PostgreSQL server logs to users via SQL
Easily expose PostgreSQL database logs to users - there’s a pretty neat way for SQL-based access! Here's a quick demo on that.
PostgreSQL instance level encryption
There are a few different ways to implement database encryption - commonly on the operating system, filesystem, file or column […]
Introducing pg_squeeze - a PostgreSQL extension to auto-rebuild bloated tables
pg_squeeze is a PostgreSQL extension implementing a background worker process that can monitor tables and and rebuild them automatically!
Best of PostgreSQL 9.6 for the Developer
After our DBA post a few days ago, today we present you the best of PostgreSQL 9.6 features from the view of a PostgreSQL Developer.
Best of PostgreSQL 9.6 for the DBA
Here arethe most interesting and relevant features of PostgreSQL 9.6 for the PostgreSQL DBA - summarized for easy digestion.
Connection pooling intro - PgBouncer and pgpool-II
Connection pooling in a Postgres context: two products stand out - PgBouncer and pgpool-II. We compared both and give you insights!
The "synchronous_commit" parameter and streaming replication
If you're not yet familiar with the "synchronous_commit" parameter, keep reading. It's one of the most important PostgreSQL parameters.