Re: pgsql: Tweak order of operations in BitmapHeapNext() to avoid the case - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: pgsql: Tweak order of operations in BitmapHeapNext() to avoid the case
Date
Msg-id 87ab9wl9x2.fsf@oxford.xeocode.com
Whole thread Raw
Responses Re: pgsql: Tweak order of operations in BitmapHeapNext() to avoid the case  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
tgl@postgresql.org (Tom Lane) writes:

> Log Message:
> -----------
> Tweak order of operations in BitmapHeapNext() to avoid the case of prefetching
> the same page we are nanoseconds away from reading for real.  There should be
> something left to do on the current page before we consider issuing a prefetch.

Doesn't this break things if, say, there's precisely one tuple on every page?
You'll keep raising the prefetch_target but never actually prefetch anything.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about
EnterpriseDB'sPostgreSQL training!
 


pgsql-hackers by date:

Previous
From: "Guillaume Smet"
Date:
Subject: Re: Recovery Test Framework
Next
From: Bruce Momjian
Date:
Subject: Re: Proposal: new border setting in psql