Discarding relations from FSM - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Discarding relations from FSM
Date
Msg-id 20050924230450.GQ7630@pervasive.com
Whole thread Raw
Responses Re: Discarding relations from FSM
Re: Discarding relations from FSM
List pgsql-hackers
Per http://lnk.nu/developer.postgresql.org/43b.c:
* The number of distinct relations tracked is limited by a configuration* variable (MaxFSMRelations).  When this would
beexceeded, we discard the* least recently used relation.  A doubly-linked list with move-to-front* behavior keeps
trackof which relation is least recently used.
 

Rather than keeping track of which relation was last used (presumably
everytime something hits the FSM), wouldn't it make more sense to just
drop the relation with the smallest amount of free space in the map?

Of course maybe a better question is why we even limit based on the
number of relations...
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: questionable item in HISTORY
Next
From: Bruce Momjian
Date:
Subject: Re: 2 forks for md5?