X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 47C3E3A47A0 for ; Thu, 18 Nov 2004 19:46:46 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 16037-04 for ; Thu, 18 Nov 2004 19:46:43 +0000 (GMT) Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by svr1.postgresql.org (Postfix) with SMTP id 899023A45E7 for ; Thu, 18 Nov 2004 19:46:43 +0000 (GMT) Received: (qmail 6282 invoked from network); 18 Nov 2004 19:46:37 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.36?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 18 Nov 2004 19:46:37 -0000 Message-ID: <419CFC21.3080402@fastcrypt.com> Date: Thu, 18 Nov 2004 14:46:41 -0500 From: Dave Cramer Reply-To: pg@fastcrypt.com Organization: Postgres International User-Agent: Mozilla Thunderbird 0.9 (X11/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-performance@postgresql.org Subject: Re: Interaction between Free Space Map an alternate location References: <419CD734.2020301@fastcrypt.com> <18536.1100803097@sss.pgh.pa.us> In-Reply-To: <18536.1100803097@sss.pgh.pa.us> Content-Type: multipart/alternative; boundary="------------000801070606070709080904" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=HTML_20_30, HTML_MESSAGE, HTML_TITLE_EMPTY X-Spam-Level: * X-Archive-Number: 200411/296 X-Sequence-Number: 9250 This is a multi-part message in MIME format. --------------000801070606070709080904 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Ok, so the global part of the fsm is just that it is in shared memory. If certain databases have more free space they will simply take up more of the fsm. There is no cross database movement of tuples. ( I realized this when I tried to form my next question) Dave Tom Lane wrote: >Dave Cramer writes: > > >>Can someone explain how the free space map deals with alternate database >>locations? >> >> > >It doesn't really care. It identifies tables by database OID+table OID, >and where they happen to sit physically doesn't matter. > > regards, tom lane > >---------------------------(end of broadcast)--------------------------- >TIP 7: don't forget to increase your free space map settings > > > > -- Dave Cramer http://www.postgresintl.com 519 939 0336 ICQ#14675561 --------------000801070606070709080904 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Ok, so the global part of the fsm is just that it is in shared memory.  If certain databases have more
free space they will simply take up more of the fsm. There is no cross database movement of tuples.
( I realized this when I tried to form my next question)

Dave

Tom Lane wrote:
Dave Cramer <pg@fastcrypt.com> writes:
  
Can someone explain how the free space map deals with alternate database 
locations?
    

It doesn't really care.  It identifies tables by database OID+table OID,
and where they happen to sit physically doesn't matter.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings


  

-- 
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561
--------------000801070606070709080904--