How a bad network configuration can cause table bloat
by
Laurenz Albe |
01.2018(Updated 2023-04-20) I recently had an interesting support case with table bloat that shows how the cause of a problem […]
ALTER TABLE: High-Availability taken care of
Adding columns, dropping columns,... might be necessary. But changing data structures should not be done mindlessly. Use ALTER TABLE wisely.
PostgreSQL: Speeding up GROUP BY and joins
Most people actually implement aggregations slightly wrong in PostgreSQL. This blogpost shows how to spped up group by and joins.
Searching for the best compromise: “Skyline” queries
What about making more intelligent queries in PostgreSQL? Skyline queries could be the answer for you. We show you how to set them up.
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.
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.
