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
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 |