Finding and Fixing Slow Queries with Pg_stat_statements (pginsights.dev) 1 points by jerrypenna 1mo ago ↗ HN
[–] jerrypenna 1mo ago ↗ I wrote the guide as I've had multiple performance issues after postgres on prem to AWS and oracle to postgres migrations.I find it easier and more efficient to have the sql ready and a comprehensive performance queries.One mistake I made was miscalculating the ratio for vacuum threshold and as a result the auto vacuum didn't run.Any suggestions or corrections, let me know.
2 comments
[ 2.5 ms ] story [ 24.5 ms ] threadI find it easier and more efficient to have the sql ready and a comprehensive performance queries.
One mistake I made was miscalculating the ratio for vacuum threshold and as a result the auto vacuum didn't run.
Any suggestions or corrections, let me know.