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

From Bruce Momjian
Subject Re: Discarding relations from FSM
Date
Msg-id 200509250120.j8P1K3E17999@candle.pha.pa.us
Whole thread Raw
In response to Re: Discarding relations from FSM  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
Jim C. Nasby wrote:
> On Sat, Sep 24, 2005 at 07:21:19PM -0400, Tom Lane wrote:
> > > Of course maybe a better question is why we even limit based on the
> > > number of relations...
> > 
> > Shared memory is fixed-size.
> 
> True, but can't the fixed memory required per-relation just be shared
> with the fixed memory used to store free pages?

The assumption is that the admin wants to control the allotment of
memory, and doesn't want it to shift based on (perhaps temporary) load.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: \d on database with a lot of tables is slow
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Vacuum questions...