Re: tablespaces and non-empty directories

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, Philip Yarra <philip(at)utiba(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: tablespaces and non-empty directories
Date: 2005-11-23 00:16:00
Message-ID: 20051123001600.GH7086@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Nov 22, 2005 at 01:38:34PM -0500, Bruce Momjian wrote:
> Gavin Sherry wrote:
> > > Related question: are there plans afoot to allow specifying an alternate
> > > location for pg_xlog (or pg_delete-me-not) to save doing the shutdown-DB, mv
> > > directory to other disk, symlink, start-DB dance?
> >
> > People have discussed it but I don't know of anyone working on it.
>
> TODO has:
>
> * Allow the pg_xlog directory location to be specified during initdb
> with a symlink back to the /data location
>
> I think the only reason it is not done yet is because it is so easy to
> do for admins, and it is impossible to do while the server is running.

Along those lines, is there anything else that would benefit from being
moved? pg_clog and pg_subtrans come to mind; but maybe pg_multixact and
pg_twophase are candidates as well?
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-11-23 00:21:54 Re: TODO Item - Add system view to show free space map
Previous Message Jim C. Nasby 2005-11-23 00:07:03 Re: Improving count(*)