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

pgsql: Fix rounding problem in dynahash.c's decision about when the

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix rounding problem in dynahash.c's decision about when the
Date: 2004-11-21 22:57:02
Message-ID: 20041121225702.2CC333A4D9A@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Fix rounding problem in dynahash.c's decision about when the target
fill factor has been exceeded.  We usually run with ffactor == 1, but
the way the test was coded, it wouldn't split a bucket until the actual
fill factor reached 2.0, because of use of integer division.  Change
from > to >= so that it will split more aggressively when the table
starts to get full.

Modified Files:
--------------
    pgsql/src/backend/utils/hash:
        dynahash.c (r1.56 -> r1.57)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/hash/dynahash.c.diff?r1=1.56&r2=1.57)

pgsql-committers by date

Next:From: User ConniDate: 2004-11-22 00:33:04
Subject: press - pr: some changes and comments
Previous:From: Tom LaneDate: 2004-11-21 22:48:03
Subject: pgsql: Reduce the default size of the PortalHashTable in order to save a

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