News for hackers. Stuff that matters.

A comment on Postgres scaling advice. Parent comment

Re:Postgres scaling advice by Tostino on Tuesday January 26, 2021 @11:04AM (#25917350)
You would get predictably bad behavior and performance without the statistics collected.
[ Parent | on HN ]
Re:Postgres scaling advice by ben509 on Tuesday January 26, 2021 @01:28PM (#25919411)
Predictably bad won't result in a sudden spike in IO usage that brings down a production system. This is why Oracle has SQL profiles.
[ Parent | on HN ]
Re:Postgres scaling advice by Tostino on Tuesday January 26, 2021 @01:36PM (#25919511)
Then use something like pg_hint_plan: https://pghintplan.osdn.jp/pg_hint_plan.html (never used it myself)

I've been bitten by bad optimizer choices which took way too long to figure out how to debug / fix, so I know the pain. I do hope the PG optimizer continues improving. It's one of the weakest areas in comparison to commercial DB's IMO.

[ Parent | on HN ]