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.
Creating 1 million users in PostgreSQL
“How many users can you have in PostgreSQL?” - “Well, as many as you want.” Here's how to easily create a large number of database users.
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.
pg_crash: Making database crashes great again
pg_crash is the ultimate tool to stress test your PostgreSQL database and infrastructure as well as your high-availability infrastructure.
Distributed aggregates / aggregate pushdown in PostgreSQL
A feature from PostgreSQL 10 is related to Foreign Data Wrappers and is generally known as “aggregate pushdown”. Have a look!|
Visualizing data in PostgreSQL with R Shiny
R is excellent for data analysis and graphics. Here's how to write an R application visualize data in a PostgreSQL database with R Shiny
Autovacuum wraparound protection in PostgreSQL
Learn about one of the most misunderstood features in the PostgreSQL world: AUTOVACUUM and its “to prevent wraparound” notice.
Finding patterns in timeseries: A poor man's method
UPDATED Aug 2023: Learn a trick in PostgreSQL timeseries analysis: Look for trends or known patterns in data - encode timeseries as strings.
Writing your own aggregation functions
Database engines usually provide basic aggregate functions. This shows how to create your own code to calculate on the server side.
