On Sat, 2004-09-18 at 07:42, Ioannis Theoharis wrote:
> I'd like to ask you,
> if postgres prefetch child instances in memory ,
> whenever a parent table is sequentially scanned,
> in order to have them in there
> for the possibility the next query to ask for them.
I'm not sure exactly what you're asking (what do you mean by "child
instances?"), but in any case, PostgreSQL doesn't do any prefetching
("readahead") -- we rely on the kernel to do that if and when it's
appropriate.
-Neil