pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dave Cramer <pg@fastcrypt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Interaction between Free Space Map an alternate location
Date: Thu, 18 Nov 2004 14:46:41 -0500
Message-ID: <419CFC21.3080402@fastcrypt.com> (raw)
In-Reply-To: <18536.1100803097@sss.pgh.pa.us>
References: <419CD734.2020301@fastcrypt.com>
	<18536.1100803097@sss.pgh.pa.us>

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

view thread (5+ messages)

Message-ID: <419CFC21.3080402@fastcrypt.com>
Permalink:  ../419CFC21.3080402@fastcrypt.com/
Also on:    postgresql.org/message-id/419CFC21.3080402@fastcrypt.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: pg@fastcrypt.com, tgl@sss.pgh.pa.us
  Subject: Re: Interaction between Free Space Map an alternate location
  In-Reply-To: <419CFC21.3080402@fastcrypt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox