Re: [SPAM?] Re: PG8 Tuning

Jeff,

> > 4) pg_xlog: If you're pg_xlog is on a spindle is *only* for pg_xlog
> > you're better off.
>
> Like Mr. Stone said earlier, this is pure dogma.  In my experience,
> xlogs on the same volume with data is much faster if both are on
> battery-backed write-back RAID controller memory.  Moving from this
> situation to xlogs on a single normal disk is going to be much slower in
> most cases.

The advice on separate drives for xlog (as is all advice on that web page) is
based on numerous, repeatable tests at OSDL.

However, you are absolutely correct in that it's *relative* advice, not
absolute advice. If, for example, you're using a $100,000 EMC SAN as your
storage you'll probably be better off giving it everything and letting its
controller and cache handle disk allocation etc. On the other hand, if
you're dealing with the 5 drives in a single Dell 6650, I've yet to encounter
a case where a separate xlog disk did not benefit an OLTP application.

For Solaris, the advantage of using a separate disk or partition is that the
mount options you want for the xlog (including forcedirectio) are
considerably different from what you'd use with the main database.

--
Josh Berkus
Aglio Database Solutions
San Francisco