>
>
> 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.