Thread: "tablespace" for tranaction log?

Hi

I have noticed that my transaction log has quite large activity volume
(up to 15MB per transaction), so with the amount of data I am using I
have manually moved the pg_xlog directory to a different disk. This
allows me to have both the table space and transaction log on two
different high performance disks.
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

    create indexspace = ....

regards

thomas

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/