On Thu, Aug 30, 2018 at 10:04 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Alexander Korotkov <a.korot...@postgrespro.ru> writes: >> But I think there is another issue in sequential scan cost. We have >> zero startup cost for sequential scan. But why? > > Because it's what the mental model of startup cost says it should be.
Whose mental model? I guess the Tom Lane mind is the canonical one for this project, but I'm not sure that it entirely agrees with mine. IIRC, it was previously proposed that we ought to charge random_page_cost for the first block of a sequential scan, because at present the cost of fetching 1 block differs depending on whether we are fetching it from a heap or an index, which seems unprincipled. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company