A tentacle is a muscular hydrostat; that is, it is a boneless, coreless appendage that's essentially all-muscle. Instead of pushing and pulling off of a solid core of bone or a fluid, the muscles in a tentacle push and pull off of other muscles.
This means that, while a tentacle is really good at exerting compressive force, as well as pushing and pulling, it's not very good at handling lateral loads at all. As such, a long tentacle that's extended too far horizontally will be unable to support its own weight against gravity.
I recognize that the minimum ratio of width to length here is the dimensions of an elephant's trunk (a muscular hydrostat); that is, about 15 centimeters wide by 182-244 centimeters long, resulting in a width-to-length ratio of ~1:12 to ~1:16. Elephants can lift hundreds of kilograms with a trunk 12-16 times longer than it is wide.
However, that's what evolution dictated for the elephant, not necessarily how big a trunk/tentacle can actually get - evolution optimizes for reproductive fitness, not necessarily the coolest possible bodily structures. With that in mind, and the question of evolution defenestrated: how long is it physically capable for a tentacle or a muscular hydrostat to be relative to its width before it cannot be extended parallel to the ground without collapsing?
Assume:
that this tentacle is made out of human muscle tissue
that this tentacle is being extended on land, rather than underwater
that this tentacle is operating under Earth-standard sea-level conditions - i.e. 9.8 m/s^2 gravity, 1 atmosphere pressure, etc.
Note that I am not interested in determining what evolutionary pressures might lead to this, nor am I interested in how this might affect the biology of the creature it's attached to - i.e. things like blood flow issues or increased nutritional needs. Additionally, I am not referring to this previous question of mine; I am uninterested in how long and heavy such a thing can get relative to the animal it's attached to. All I am interested in is how long a tentacle can get relative to its width while still remaining capable of standing up under gravity.