<stuff(at)opensourceonline(dot)com> writes:
> I am working with some pretty convoluted queries that work very slowly the
> first time they're called but perform fine on the second call. I am fairly
> certain that these differences are due to the caching. Can someone point me
> in a direction that would allow me to pre-cache the critical indexes?
Buy more RAM. Also check your shared_buffers setting (but realize that
more is not necessarily better).
regards, tom lane