Re: preloading indexes
От
Тема
Re: preloading indexes
Дата
Msg-id
20041103191247.GFZT27576.fed1rmmtao07.cox.net@CYGNUS
Ответ на
Re: preloading indexes (Matt Clark)
Список
Дерево обсуждения
preloading indexes <stuff@opensourceonline.com>
Re: preloading indexes "Matt Clark" <matt@ymogen.net>
Re: preloading indexes <stuff@opensourceonline.com>
Re: preloading indexes Andrew Sullivan <ajs@crankycanuck.ca>
Re: preloading indexes <stuff@opensourceonline.com>
Re: preloading indexes Tom Lane <tgl@sss.pgh.pa.us>
Re: preloading indexes Mike Benoit <ipso@snappymail.ca>
Re: preloading indexes <stuff@opensourceonline.com>
Re: preloading indexes Andrew Sullivan <ajs@crankycanuck.ca>
Re: preloading indexes Andrew Sullivan <ajs@crankycanuck.ca>
Re: preloading indexes Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>
Re: preloading indexes Tom Lane <tgl@sss.pgh.pa.us>
That’s correct – I’d like to be able to keep particular indexes in RAM available all the time
The best way to get all the stuff needed by a query into RAM is to run the query. Is it more that you want to 'pin' the data in RAM so it doesn't get overwritten by other queries?
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 по дате отправления
