Re: Discarding relations from FSM - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Discarding relations from FSM
Date
Msg-id 25176.1127604079@sss.pgh.pa.us
Whole thread Raw
In response to Discarding relations from FSM  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Discarding relations from FSM
List pgsql-hackers
"Jim C. Nasby" <jnasby@pervasive.com> writes:
> 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?

Why?  That certainly wouldn't be cheaper to track.

> Of course maybe a better question is why we even limit based on the
> number of relations...

Shared memory is fixed-size.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: \x output blowing up
Next
From: "Jim C. Nasby"
Date:
Subject: \d on database with a lot of tables is slow