Tag

#postgresql performance

Published posts with this tag.

10/30/2026

How to Find and Terminate Long-Running PostgreSQL Queries

Find postgresql long running queries with pg_stat_activity and pg_blocking_pids, stop them safely with pg_cancel_backend or pg_terminate_backend, and add timeouts.

software development Web Application Development

By Muhammad Wilayat Shah

Read

10/30/2026

PostgreSQL Read Replicas vs Database Sharding

Compare postgresql read replicas and sharding for read-heavy apps: replication lag, Laravel sticky reads and when sharding is actually justified.

software development Web Application Development

By Muhammad Wilayat Shah

Read