What is autovacuum doing to my temporary tables?
The main issue is that autovacuum does not touch temporary tables. Yes, it’s true – you have to VACUUM temporary tables on your own. Read more
How PostgreSQL estimates parallel queries
How to understand parallel queries - estimate the cost of sequential scans and parallel sequential scans in PostgreSQL
Fixing track_activity_query_size in postgresql.conf
How to use track_activity_query_size, a configuration parameter that determines when a query will be cut off. Use it to your advantage.
Using “Row Level Security” to make large companies more secure
How to use row level security to restrict internal access to PostgreSQL databases. How to configure access restrictions dynamically.
PostgreSQL Row Level Security, views and a lot of magic
How to implement row-level security in PostgreSQL and views. Shows examples and corner cases to watch out for.
Timeseries: EXCLUDE TIES, CURRENT ROW and GROUP
UPDATED 2023: How to use advanced SQL for timeseries in PostgreSQL - window functions, analytics. EXCLUDE TIES, CURRENT ROW & GROUP
PostgreSQL: Trivial timeseries examples
How to use the PostgreSQL function lag() and corr() - see basic examples and get familiar with window functions for trivial timeseries.
Composite/ combined indexes vs. separate indexes in PostgreSQL
What is more beneficial: Using separate or combined indexes in your PostgreSQL database? Speed performance by understanding index scans.
PostgreSQL: How are functions and stored procedures replicated?
How are functions replicated in PostgreSQL? Find out about functions, stored procedures and replication. What happens to shared libraries & do I need to install an extension everywhere?
PostgreSQL meets “Data Science and AI”
PostgreSQL helps to achieve Data Science goals, and offers reliable backend storage for your data. Find out about great ML tools.
