2 comments

[ 2.5 ms ] story [ 24.5 ms ] thread
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.