In Chapter 3 of Kardar's statistical physics of fields, in the context of lower critical dimension, he works out an example about superfluids where starting from the probablity of a particular configuration in the ordered phase, ie $$\mathscr{P}[\theta(\mathbf{x})] \propto \exp\left\lbrace-\frac{K}{2} \int \mathrm{d}^d\mathbf{x} (\nabla\theta)^2\right\rbrace,$$ where $\theta$ is the phase of the wavefunction, he goes on to calculate the correlation functions, obtaining $$ \left\langle \theta(\mathbf{x})\theta(\mathbf{x}')\right\rangle = - \frac{C_d(\mathbf{x}-\mathbf{x}')}{K},$$ where $$ C_d(\mathbf{x}) = - \int \frac{\mathrm{d}^d\mathbf{q}}{(2\pi)^d} \frac{e^{i\mathbf{q}\cdot\mathbf{x}}}{\mathbf{q}^2}$$ is presumebly the Coulomb potential in $d$ dimensions since $$\nabla^2 C_d(\mathbf{x}) = \delta^d(\mathbf{x}).$$ He then uses the Gauss theorem, ie $$ \int \mathrm{d}^d\mathbf{x} \nabla^2 C_d = \oint \mathrm{d}S\cdot\nabla C_d$$ together with $\nabla C_d = (\mathrm{d}C_d/\mathrm{d}r)\hat{r}$, which simply is due to the spherical symmetry, to build the solution \begin{equation} C_d(x) = \frac{x^{2-d}}{(2-d)S_d} + c_0, \end{equation} where $S_d$ is the area of unit sphere in $d$ dimensions and $c_0$ a constant to be determined. Then it is argued that this clearly diverges for $d \leq 2$ dimesnions as $x\to\infty$, while approaches $c_0$ for $d>2$. This is however related to the celebrated Mermin-Wagner theorem.
Now my question is that it seems to me $C_d(\mathbf{x})$ is a divergent integral as the integrand doesn't decay fast enough when $\mathbf{q}\to\infty$, except in $d=1$. So I would naively guess the integral is convergent in $d=1$, while in $d \geq 2$ it diverges, which is exactly opposite what Kardar claims.
I guess there is some type of regularization scheme at work in Kardar's approach (maybe momentum cutoff or dimensional regularization), but I don't understand it exactly and in which of the steps outlined above it's been applied. I tried calculating the integral directly (in the $d$ dimensional sphereical coordinates) hoping that I can apply the momentum cutoff on the final result and compare it with Kardar's solution, but have no clue how to do the calculation since the angle between $\mathbf{q}$ and $\mathbf{x}$ introduced by $e^{i\mathbf{q}\cdot\mathbf{x}}$ makes it complicated.
EDIT
I see the integral needs probably both lower and upper cutoffs (say $\Lambda_l$ and $\Lambda_u$) to converge, depending on the dimensionality of the space so \begin{equation} C_d(\mathbf{x}) = \lim_{\substack{\Lambda_u\to\infty \\ \Lambda_l \to 0}} \left\lbrace\mathcal{F}(|\mathbf{x}|) + \mathcal{G}(\Lambda_{u}, \Lambda_{l}) + c_0\right\rbrace. \end{equation} (The above form probably needs justification)
Then one argues the function $\mathcal{G}$ doesn't affect the correlations meaningfully (it is just a constant that approaches infinity) and we only study the behavior of function $\mathcal{F}$. My question is how to make sure the manipulation in Kardar's book is exactly doing this.