> From: Aleksei Valikov
>
<snip>
> Moreover, what I find very strange is that when I log in with psql (or
> any other SQL client) onto the production database and execute the same
> query, it runs fast - even in peak hours!
>
<snip>
That is strange. Is this a networking issue? Are your clients becoming memory
bound (e.g. not enough RAM or poor garbage collection/memory leakage on the
client side)?
Best regards,
Jim Wilson