preloading indexes

From: <stuff(at)opensourceonline(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: preloading indexes
Date: 2004-11-03 17:30:47
Message-ID: 20041103173054.EJWF21506.fed1rmmtao05.cox.net@CYGNUS
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Matt Clark 2004-11-03 17:59:02 Re: preloading indexes
Previous Message Andrew Sullivan 2004-11-03 14:17:43 Re: Restricting Postgres