Let $f$ be a non-negative function defined on the unit interval. It is well known that $N(p) := \left(\int_0^1 f^p(t) dt\right)^{\frac{1}{p}} $ converges to $\operatorname{esssup}_{[0,1]} f$ when $p \to \infty$.
I am interested in the case when $\operatorname{esssup}_{[0,1]} f =+\infty$ but $f \in L^p$ for all $p \in [1,\infty)$. One can show that the function $p \to N(p)$ is increasing and continuous, using the Hölder inequality.
Examples suggest to me that the growth of $N(p)$ is polynomial as $p \to \infty$ (subexpontential would suffice for me). For example, if $f(x) = \lvert\ln(x)\rvert$ then $N(p) \sim p e$, where $e$ is the Euler constant.
Of course this is hard to believe, but I was wondering if there are results/theory available about the growth of $N(p)$ as $p \to \infty$.
Any chunk of information is appreciated.