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

From Hannu Krosing
Subject Re: Discarding relations from FSM
Date
Msg-id 1127632521.4865.58.camel@fuji.krosing.net
Whole thread Raw
In response to Re: Discarding relations from FSM  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
On L, 2005-09-24 at 19:32 -0500, 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?
> 
> Though, the idea mentioned recently of just using one shared memory
> segment for everything and allocating dynamically within that probably
> makes more sense...

I guess that communicating those changes to all running backends may be
expensive.

-- 
Hannu Krosing <hannu@skype.net>



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Vacuum questions...
Next
From: Hannu Krosing
Date:
Subject: Re: \d on database with a lot of tables is slow