Heikki Linnakangas [EMAIL PROTECTED] writes:
Right, I was sloppy. Instead of table size, what matters is the amount of data
the scan needs to access. The point remains that if the data is already in OS
cache, the posix_fadvise calls are a waste of time, regardless of how many
pages ahead you
Someone wrote:
Should we consider only telling the kernel X pages ahead, meaning when
we are on page 10 we tell it about page 16?
The patch I posted specifically handles bitmap heap scans. It does in fact
prefetch only a limited number of pages from the bitmap stream based on a guc,
but it