pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Interaction between Free Space Map an alternate location for a database
5+ messages / 3 participants
[nested] [flat]

* Interaction between Free Space Map an alternate location for a database
@ 2004-11-18 17:09 Dave Cramer <pg@fastcrypt.com>
  2004-11-18 18:18 ` Re: Interaction between Free Space Map an alternate location for a database Josh Berkus <josh@agliodbs.com>
  2004-11-18 18:38 ` Re: Interaction between Free Space Map an alternate location for a database Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 5+ messages in thread

From: Dave Cramer @ 2004-11-18 17:09 UTC (permalink / raw)
  To: pgsql-performance

Can someone explain how the free space map deals with alternate database 
locations?

Given that the free space map is global, and it is ostensibly managing 
free disk space, how does it deal with tuples across disk locations ?


Dave

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




^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Interaction between Free Space Map an alternate location for a database
  2004-11-18 17:09 Interaction between Free Space Map an alternate location for a database Dave Cramer <pg@fastcrypt.com>
@ 2004-11-18 18:18 ` Josh Berkus <josh@agliodbs.com>
  2004-11-18 18:42   ` Re: Interaction between Free Space Map an alternate location Dave Cramer <pg@fastcrypt.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Josh Berkus @ 2004-11-18 18:18 UTC (permalink / raw)
  To: pgsql-performance; pg@fastcrypt.com

Dave,

> Given that the free space map is global, and it is ostensibly managing
> free disk space, how does it deal with tuples across disk locations ?

Are you talking Tablespaces?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Interaction between Free Space Map an alternate location
  2004-11-18 17:09 Interaction between Free Space Map an alternate location for a database Dave Cramer <pg@fastcrypt.com>
  2004-11-18 18:18 ` Re: Interaction between Free Space Map an alternate location for a database Josh Berkus <josh@agliodbs.com>
@ 2004-11-18 18:42   ` Dave Cramer <pg@fastcrypt.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Dave Cramer @ 2004-11-18 18:42 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance

No, have a look at the create database command

there is a clause 'with location' that allows you to set up a separate 
location for the db

Dave

Josh Berkus wrote:

>Dave,
>
>  
>
>>Given that the free space map is global, and it is ostensibly managing
>>free disk space, how does it deal with tuples across disk locations ?
>>    
>>
>
>Are you talking Tablespaces?
>
>  
>

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

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Interaction between Free Space Map an alternate location for a database
  2004-11-18 17:09 Interaction between Free Space Map an alternate location for a database Dave Cramer <pg@fastcrypt.com>
@ 2004-11-18 18:38 ` Tom Lane <tgl@sss.pgh.pa.us>
  2004-11-18 19:46   ` Re: Interaction between Free Space Map an alternate location Dave Cramer <pg@fastcrypt.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Tom Lane @ 2004-11-18 18:38 UTC (permalink / raw)
  To: pg@fastcrypt.com; +Cc: pgsql-performance

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Interaction between Free Space Map an alternate location
  2004-11-18 17:09 Interaction between Free Space Map an alternate location for a database Dave Cramer <pg@fastcrypt.com>
  2004-11-18 18:38 ` Re: Interaction between Free Space Map an alternate location for a database Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-11-18 19:46   ` Dave Cramer <pg@fastcrypt.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Dave Cramer @ 2004-11-18 19:46 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-performance

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

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2004-11-18 19:46 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-18 17:09 Interaction between Free Space Map an alternate location for a database Dave Cramer <pg@fastcrypt.com>
2004-11-18 18:18 ` Josh Berkus <josh@agliodbs.com>
2004-11-18 18:42   ` Re: Interaction between Free Space Map an alternate location Dave Cramer <pg@fastcrypt.com>
2004-11-18 18:38 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-11-18 19:46   ` Re: Interaction between Free Space Map an alternate location Dave Cramer <pg@fastcrypt.com>

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