Re: "tablespace" for tranaction log?

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Thomas Finneid <tfinneid(at)fcon(dot)no>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: "tablespace" for tranaction log?
Date: 2009-01-24 22:11:11
Message-ID: 497B91FF.60707@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Thomas Finneid escreveu:
> But my question is, since I can do this with tablespace for tables,
> indexes and so on, is there any possibilites to do a similar thing for
> the transaction log from inside postgres? as in
>
No. Because transaction log is for the entire cluster and it is too risky to
do such a change when the server is running. You need to stop the database and
make the change. Also, you can setup the xlog to a different location at
initdb time.

--
Euler Taveira de Oliveira
http://www.timbira.com/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2009-01-25 07:26:44 Re: SSD performance
Previous Message Scott Marlowe 2009-01-24 19:32:58 Re: strange index performance?