Problem while pg_xlog directory

From: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem while pg_xlog directory
Date: 2010-12-13 13:47:03
Message-ID: 4D0623D7.8040007@orkash.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all,

I am doing some Performance tuning in Pgsql. I have changed several
Parameters in postgresql.conf file. Now I want to change my pg_xlog
directory to another disk.

I followed the below steps :

cd /hrd2-p/postgres_data
> /etc/init.d/postgresql-8.4 stop
> mkdir -p /opt/pg_xlog
> chown -R postgres.postgres /opt/pg_xlog
> chmod 700 /opt/pg_xlog
> cp -rf pg_xlog/* /opt/pg_xlog
> mv pg_xlog pg_xlog_old
> ln -s /opt/pg_xlog pg_xlog
> /etc/init.d/postgresql-8.4 start

But me server fail to start and there is empty log in startup.log. I also checked my permissions and directories are owned by postgres user.

Is I am failing something and there is some simple way.

Also, i want to know after Performance tuning following the below link :

http://wiki.postgresql.org/wiki/Performance_Optimization.

How much our performance increases.

I am selecting data from 5Gb file and it takes 229477 ms.
Still i execute same query in 226977 ms after some tuning.

Please help.

Best Regards

Adarsh Sharma

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2010-12-13 13:53:44 Re: pg_dump order of rows
Previous Message Vick Khera 2010-12-13 13:44:49 Re: Using regexp_replace to remove small words