Shorn
Joined 9 years ago
Joined 9 years ago
There's your answer right there, no need to ask.
Without human advice and a metric shit-tonne of guidance (either pre or post) - anything that requires active consideration of future maintenance burden will cost you 2x-10x of the time you think "saved" over a medium-term time-frame.
The alternative is to spend at least 50% (or sometimes up to %100) of the "saved" time in active review and iterative improvement of the solution design.
Yeah, no corporate bias here whatsoever
Sooo.... "be more professional in your writing"?
Why does this person owe you "professional writing" on their personal comment?
The version of postgres you think you're specifying isn't exactly the community postgres, it's an AWS maintained fork and this is an example of where they were seeing an error message from a future version of postgres that had been back-ported in the fork (or maybe AWS contributed to PG and it landed in a later version).
---
I guess I knew this - it's obviously not the exact same version, when you stop to think about it (pretty sure the doco tells you this explicitly too).
But I've never personally observed a difference, so I never really gave it a thought.
> "I think we've become so negative about hints that we rarely have a rational discussion about them... I also don't enjoy telling a customer 'hey, I know this query started misbehaving in the middle of the night on Christmas, but hints are bad... you can just have your web site be down for the next 20 years while we try to improve the optimizer.'"
https://www.mail-archive.com/[email protected]....
Above quote is from the author of pg_plan_advice itself, from a few years ago.
So given his proposal isn't just band-aiding query hints into PG, is from a committer instead of being a drive-by patch, and might be even more generally useful/applicable than "add query hints" - maybe we could see some movement here.
[1] - I say this as a daily user of claude-code, paying $200USD/mth, of my own money, BTW.
If you're building a brand new, multi-language, multi-platform system that uses advanced open-api features - you will get bitten by lack of support in 3.1 versions of tooling for features that already existed and work fine right now in 3.0 tool versions. Especially if you're using a schema-first workflow (which you should be). For example, $ref's to files across windows/linux/macos across multiple different language tools - java, .net, typescript, etc.
If you need (or just want) maximum compatibility across tools, platforms and languages - open-api 3.1 is still not viable, and isn't looking like it will be anytime soon.
My current SaaS project is https://kopi.cloud, it lets you keep your email address private via email forwarding / mail-to-rss functionality.