[PERFORM] XFS External Log on Pg 7.4.8 Pg_xlog drives?

2005-10-10 Thread Steve Poe 
Fellow Postgresql users,

I have a Pg 7.4.8 data on XFS RAID10 6-disc (U320 SCSI on LSI MegaRAID
w/bbu). The pg_xlog is on its own RAID1 with nothing else.

I don't have room for more drives, but I am considering moving the XFS
external log of the data directory to the RAID1 where the pg_xlog
exists. Unfortunately, I don't have room on the RAID1 that the OS exists
on(Centos Linux 4.1).

Anyone have any experience moving the XFS log to the pg_xlog? The
guessing the the benefit / cost will cancel each other out. 

Thanks.

Steve Poe


---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [PERFORM] XFS External Log on Pg 7.4.8 Pg_xlog drives?

2005-10-10 Thread Michael Stone 

On Mon, Oct 10, 2005 at 03:28:42PM -0700, Steve Poe wrote:

I don't have room for more drives, but I am considering moving the XFS
external log 


There is absolutely no reason to move the xfs log on a system that
small. 


Mike Stone

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match