preloading indexes - Mailing list pgsql-performance

From
Subject preloading indexes
Date
Msg-id 20041103173054.EJWF21506.fed1rmmtao05.cox.net@CYGNUS
Whole thread Raw
Responses Re: preloading indexes  ("Matt Clark" <matt@ymogen.net>)
Re: preloading indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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?

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Restricting Postgres
Next
From: "Matt Clark"
Date:
Subject: Re: preloading indexes