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? |
- Re: [PERFORM] preloading indexes stuff
- Re: [PERFORM] preloading indexes Matt Clark
- Re: [PERFORM] preloading index... stuff
- Re: [PERFORM] preloading i... Andrew Sullivan
- Re: [PERFORM] preloadi... Pierre-Frédéric Caillaud
- Re: [PERFORM] preloadi... stuff
- Re: [PERFORM] pre... Tom Lane
- Re: [PERFORM]... stuff
- Re: [PERFORM]... Mike Benoit
- Re: [PERFORM] pre... Andrew Sullivan
- Re: [PERFORM]... Andrew Sullivan