Skip site navigation (1) Skip section navigation (2)

Re: tablespaces and DB administration

From: Marty Scholes <marty(at)outputservices(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Marty Scholes <marty(at)outputservices(dot)com>, josh(at)agliodbs(dot)com
Subject: Re: tablespaces and DB administration
Date: 2004-05-28 15:52:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Josh Berkus wrote:

 > The whole point of tablespaces is to
 > allow placing individual tables and indexes
 > on seperate volumes.

That was one reason.  I seem to recall several more:

* Putting data on cost appropriate media
Mentioned previously in this thread

* Balancing I/O across spindles
Also mentioned previously, many times

* Inode stability
The free space bitmap never changes during production.  The inode table 
never changes during production (save for last modified and last 
accessed timestamps).  This makes the filesystem VERY likely to be 
functional in case of a crash.  Jounaled file systems have reduced the 
need for this.

* Device independence
Since a tablespace needs only some "file names" and the ability to 
lseek() to any point in a file, a tablespace file can be a file on the 
UFS (or its variantes), a disk partition, or even a tape drive device.

pgsql-hackers by date

Next:From: Philip WarnerDate: 2004-05-28 15:58:46
Subject: Re: pg_dump --comment?
Previous:From: Alvaro HerreraDate: 2004-05-28 15:46:07
Subject: Re: Nested xacts: looking for testers and review

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group