On Fri, Mar 9, 2012 at 5:21 AM, Robert Haas <[email protected]> wrote: > On Fri, Mar 9, 2012 at 5:24 AM, Fujii Masao <[email protected]> wrote: >> When a relation is loaded into cache, are corresponding indexes also loaded >> at the same time? > > No, although if you wanted to do that you could easily do so, using a > query like this: > > select pg_prewarm(indexrelid, 'main', 'read', NULL, NULL) from > pg_index where indrelid = 'your_table_name'::regclass;
Could that be included in an example? Maybe admins are expected to know how to construct such queries of the cuff, but I always need to look it up each time which is rather tedious. In the patch: s/no special projection/no special protection/ Thanks for putting this together. Cheers, Jeff -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
