The usage of max(id) - min(id) to speed up count(*) may seem like a good approach when it comes to speeding up the process, but it can be problematic.
How to use MobilityDB for contact tracking. Extension built on top of PostGIS, specializing on processing and analysing spatio-temporal data
UPDATE July 2023: What could be better in PostgreSQL? Find out about its weak points, and see what has improved since 2020.
Most people know that autovacuum is necessary to get rid of dead tuples. These dead tuples are a side […]
(Updated 2023-02-22) In my daily work, I see many databases with a bad setting for max_connections. There is little […]
PostGIS' functions can be used to trace down infected people and their contact with healthy individuals | GPS-Tracks | spatial data
How to use pg_show_plans to look at execution plans of slow queries in real time as they’re being executed | Troubleshooting tool
How to predict the behavior of a variable over time. Learn about time series forecasting in a machine learning context.
Performance differences between normal and generic audit triggers | PostgreSQL database | PostgreSQL trigger performance
pg_show_plans is an extension developed by CYBERTEC, which shows all active query plans in PostgreSQL | Execution plan live in PostgreSQL
Embedded SQL is by no means a new feature — in fact it is so old-fashioned that many people […]
pg_timetable: Advanced PostgreSQL cron-like scheduler released! Hello there, this is your developer speaking... I'm struggling with how to start this […]
