Re: Discarding relations from FSM

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Discarding relations from FSM
Date: 2005-09-24 23:21:19
Message-ID: 25176.1127604079@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Jim C. Nasby" <jnasby(at)pervasive(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2005-09-24 23:59:24 \d on database with a lot of tables is slow
Previous Message Bruce Momjian 2005-09-24 23:18:16 Re: \x output blowing up