This question is inspired by Rudin's Real and Complex Analysis Chapter 3 Problem 5 part (c), which asks for conditions that guarantee that $L^r(\mu)= L^s(\mu)$ for $0<r<s$ on a measure space $(X,\mu)$ which has $\mu(X)=1$. It is not hard to see that if $X$ consists of finitely many elements, the $\sigma$-algebra $\mathcal M$ is the power set, and $\mu$ is finite on $X$, then $L^p(\mu)=L^q(\mu)$ for any $p,q\in(0,\infty]$. We can also consider finite $\sigma$-algebras on arbitrarily large sets $X$, and should obtain the same result.
What I would like to know, as a curiosity, is if this is essentially the only non-trivial situation. My intuition says that it should be, for in the situation of an infinite (hence, uncountable) $\sigma$-algebra on a set $X$ with infinite cardinality, we should be able to construct a measurable function $f$ which lies in $L^q$ but does not lie in $L^r$ for $r>q$.