PostgreSQL: Indexes and foreign keys
Missing indexes and foreign keys may cause database performance problems. Learn how to speed up things dramatically - not only in PostgreSQL!
A quick check on Postgres 10 Beta Analytics Performance vs version 9.6
Is +40% performance improvement real? We did a quick check on PostgreSQL 10 Beta Analytics Performance vs PostgreSQL 9.6.
int4 vs int8 vs uuid vs numeric performance on bigger joins
Brief overview of the performance of different datatypes on bigger joins. How much performance gets lost? Which one is better? Have a look!
Composite types in PostgreSQL: (func()).* - Hidden performance issues
Using composite types offers db developers a great deal of flexibility. Passing complex data to functions is a lot easier.
Checkpoint distance and amount of WAL
Tuning the database server affects the amount of WAL written to disk. Fewer checkpoints are a good idea for bigger databases.
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.
Parallel queries and SERIALIZABLE transactions
In version 9.6 PostgreSQL introduced parallel queries. The ability to use more than just one CPU core per query is […]
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!
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!
