Re: [HACKERS] pre-loading a user table.

2004-04-02 Thread Zeugswetter Andreas SB SD
Why do you think it useful to preload something during InitPostgres, anyway? Any heavily used table will certainly be present in shared buffers already, and even more surely present in kernel buffers. And if you really want it preloaded you can issue dummy selects with a client right after

[HACKERS] pre-loading a user table.

2004-04-01 Thread Ana Cerejo
I am trying a pre-load a user table during InitPostgres. I tried to mimic the relevant actions in ReverifyDatabase to carry this out. I manage to load the first block of the table. However, if a table is more than 1 block, I end up getting warnings about relcache reference leaks. It looks

Re: [HACKERS] pre-loading a user table.

2004-04-01 Thread Tom Lane
Ana Cerejo [EMAIL PROTECTED] writes: I am trying a pre-load a user table during InitPostgres. I tried to mimic the relevant actions in ReverifyDatabase to carry this out. I manage to load the first block of the table. However, if a table is more than 1 block, I end up getting warnings