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

tablespaces and DB administration

From: pgsql(at)mohawksoft(dot)com
To: pgsql-hackers(at)postgresql(dot)org
Subject: tablespaces and DB administration
Date: 2004-05-26 20:25:24
Message-ID: 16698.24.91.171.78.1085603124.squirrel@mail.mohawksoft.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Now that it looks like tablespaces will become a practical reality, I want
to suggest some changes in documented procedure and preferred setup. The
reason why I suggest these changes is to enlighten new PostgreSQL users to
the new features and, perhaps, make a more enterprise-familiar environment
for experienced DBAs.

First, we keep the standard PostgreSQL directory the way it has always
been with template0, template1, pg_xlog, pg_clog, etc. in the same place.
We can refer to this as the "system" directory. This makes sense because
all the system level stuff is there. User databases should be discouraged
from the system, and users should be encouraged to create and use separate
tablespaces for their databases.

This is usefull for a couple of reasons: 1st, it makes monitoring database
size easier while also simplifying xlog monitoring, as well as makes a
logical separation from the PostgreSQL operational core and its external
data. 2nd, this is very similar to how other databases view data.

What do you all think?

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-05-26 20:33:31
Subject: Re: tablespaces and DB administration
Previous:From: Bruce MomjianDate: 2004-05-26 18:48:37
Subject: Re: [HACKERS] pg_autovacuum fixes

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