Re: Warm-cache prefetching

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> I can see that being useful for a single-user application that doesn't
> have locking or I/O bottlenecks, and doesn't have a multi-stage design
> like a database. Do we do enough of such processing that we will _see_
> an improvement, or will our code become more complex and it will be
> harder to make algorithmic optimizations to our code?

The main concern I've got about this is the probable negative effect on
code readability. There's a limit to the extent to which I'm willing to
uglify the code for processor-specific optimizations, and that limit is
not real far off. There are a lot of other design levels we can work at
to obtain speedups that won't depend on the assumption we are running
on this-year's Intel hardware.

regards, tom lane