Skip site navigation (1) Skip section navigation (2)

cost_nonsequential_access()

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: pgsql-patches(at)postgresql(dot)org
Subject: cost_nonsequential_access()
Date: 2004-06-08 08:15:21
Message-ID: gbsac0l2q1j07tc2j9aimavc5o92lp2ifa@email.aon.at (view raw or flat)
Thread:
Lists: pgsql-patches
The comment describing cost_nonsequential_access() says that the two
functions "meet in the middle".  They meet at random_page_cost/2,
however, not in the middle between 1 and random_page_cost.  For
random_page_cost < 2 the result can be less than 1 for relpages near
effective_cache_size.  I don't think that this was intended.

This patch makes sure that cost_nonsequential_access() is always between
1 and randon_page_cost and the functions meet a (1+random_page_cost)/2.

Servus
 Manfred

Responses

pgsql-patches by date

Next:From: Bruce MomjianDate: 2004-06-08 13:49:22
Subject: Re: Relocatable locale
Previous:From: Peter EisentrautDate: 2004-06-08 07:55:32
Subject: Re: Relocatable locale

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group