Performance tunning

Поиск
Список
Период
Сортировка
Искать

Performance tunning

От:
Romildo Wildgrube <romildo@ragingnet.com>
Дата:
Hi,

According to some postings it looks like there is a recommendation to 
separate the database files from the transaction logs into separated 
disk/raid. I was wondering if someone know where the transaction logs 
are setup and how can I change to point to a new location.

Romi

Re: Performance tunning

От:
"scott.marlowe" <scott.marlowe@ihs.com>
Дата:
On Mon, 28 Jul 2003, Romildo Wildgrube wrote:

> Hi,
> 
> According to some postings it looks like there is a recommendation to 
> separate the database files from the transaction logs into separated 
> disk/raid. I was wondering if someone know where the transaction logs 
> are setup and how can I change to point to a new location.

Your transaction logs and commit logs are in pg_xlog and pg_clog 
respectively in your $PGDATA directory.  first, shut down the database:  
'pg_ctl stop'  Then copy them elsewhere, rename the source directory 
(don't delete until you're sure everything is working) and then link the 
new directories under $PGDATA:

pg_ctl stop
cd $PGDATA
mkdir someotherplace/pg_xlog
mkdir someotherplace/pg_clog
cp -Rfp pg_xlog/* someotherplace/pg_xlog/
cp -Rfp pg_clog/* someotherplace/pg_clog/
mv pg_xlog pg_xlog_old
mv pg_clog pg_clog_old
ln -s someotherplace/pg_xlog/ pg_xlog
ln -s someotherplace/pg_clog/ pg_clog
pg_ctl start

That should do it.




FAQ