X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 2433D52874
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu,  2 Jun 2005 04:02:18 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 87619-03
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Thu,  2 Jun 2005 07:02:12 +0000 (GMT)
Received: from web51005.mail.yahoo.com (web51005.mail.yahoo.com
	[206.190.38.136])
	by svr1.postgresql.org (Postfix) with SMTP id 94DE852869
	for <pgsql-performance@postgresql.org>;
	Thu,  2 Jun 2005 04:02:10 -0300 (ADT)
Received: (qmail 96755 invoked by uid 60001); 2 Jun 2005 07:02:09 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=dhB3Z+mGbLTZcmi2Zqr6OYizrYy+K1u1TjovQaZwgv3+Z9pP9dQtliXTjwkp51m+h0ts08UpomyUmOdSWoQTbV+qXCO9l5ZIAhVVxzFU+UyUo4zqMgQ5Klne1DxyUjhoXeZAY3Z0YdfmK8D+71ydUmFiLUn56UQJLcuB0KfyBLg=
	;
Message-ID: <20050602070209.96753.qmail@web51005.mail.yahoo.com>
Received: from [203.101.103.131] by web51005.mail.yahoo.com via HTTP;
	Thu, 02 Jun 2005 00:02:09 PDT
Date: Thu, 2 Jun 2005 00:02:09 -0700 (PDT)
From: Himanshu Baweja <himanshubaweja@yahoo.com>
Subject: Re: Moving pg_xlog
To: pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1003934382-1117695729=:94860"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.4 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, HTML_10_20, HTML_MESSAGE
X-Spam-Level: *
X-Archive-Number: 200506/28
X-Sequence-Number: 12666

--0-1003934382-1117695729=:94860
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

My database has two scsi disks....
my current configuration has pg_xlog on disk1 and data on disk2....
the machine is used for database only....
now did some logging and came to a conclusion that my disk2(data disk) is getting used around 3 times more than disk1(pg_xlog)....
 
so wht is recommended... move some of the data to disk1 so that both disks are equally used... by creating tablespaces or let my configuration be whts its currently... iowait is one of the bottlenecks in my application performance.....
 
thx
Himanshu

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--0-1003934382-1117695729=:94860
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>My database has two scsi disks....</DIV>
<DIV>my current configuration has pg_xlog on disk1 and data on disk2....</DIV>
<DIV>the machine is used for database only....</DIV>
<DIV>now did some logging and came to a conclusion that my disk2(data disk) is getting used around 3 times more than disk1(pg_xlog)....</DIV>
<DIV>&nbsp;</DIV>
<DIV>so wht is recommended... move some of the data to disk1 so that both disks are equally used... by creating tablespaces or let my configuration be whts its currently... iowait is one of the bottlenecks in my application performance.....</DIV>
<DIV>&nbsp;</DIV>
<DIV>thx</DIV>
<DIV>Himanshu</DIV><p>__________________________________________________<br>Do You Yahoo!?<br>Tired of spam?  Yahoo! Mail has the best spam protection around <br>http://mail.yahoo.com 
--0-1003934382-1117695729=:94860--