On Tue, Aug 16, 2005 at 09:12:31AM -0700, Josh Berkus wrote:

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

I've been asked this a couple of times and I don't know the answer: what
happens if you give XLog a single drive (unmirrored single spindle), and
that drive dies?  So the question really is, should you be giving two
disks to XLog?

Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"[PostgreSQL] is a great group; in my opinion it is THE best open source
development communities in existence anywhere."                (Lamar Owen)

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to