PostGIS performance basics. Second post in a series covering pg_stat_statements, shared buffers, work_mem, and parallel queries.

CrunchyData's platform is a central hub for PostgreSQL professionals and database administrators, offering insights into PostgreSQL deployment, administration, and optimization. Through articles, tutorials, and case studies, CrunchyData offers insights into PostgreSQL features, replication strategies, and high availability architectures. Readers can learn about database performance tuning, backup and recovery procedures, and security best practices to ensure the reliability and security of their PostgreSQL deployments.

Crunchy Data

Learn how to identify and resolve PostgreSQL performance issues using pg_stat_statements to track slow queries, and optimize system-level settings including shared buffers for cache hit ratios, work_mem for memory-intensive operations, and parallel query configuration to leverage multiple CPU cores effectively.

PostGIS Performance: pg_stat_statements and...

Showing Postgres query times with pg_stat_statements