That would entail building an AI into the code that would deal with all the possible OS(versions), Postgres(versions), hardware permutations.I... guess. If "AI" means "a series of ifs". Which is what software... is? I doubt that people who can make the world's most advanced open source database cannot check the amount of RAM and see how fast the CPU/disk is.
But the very nature of "embedded" implies the db is subservient to something else, and that something else may need most of the resources.
But I heartily agree that tuning a server can be difficult. It's highly dependent on the context and hardware resources is only a portion of that context. I've seen generous help on this list for specific configuration help.
