Re: Interaction between Free Space Map an alternate location

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Interaction between Free Space Map an alternate location
Date: 2004-11-18 18:42:49
Message-ID: 419CED29.8080904@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Woody Woodring 2004-11-18 19:04:38 Re: Query Performance and IOWait
Previous Message Tom Lane 2004-11-18 18:38:17 Re: Interaction between Free Space Map an alternate location for a database