From: John A Meinel <john@arbash-meinel.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: KeithW@narrowpathinc.com, PostgreSQL Perform <pgsql-performance@postgresql.org>
Subject: Re: Moving pg_xlog
Date: Wed, 01 Jun 2005 16:27:48 -0500
Message-ID: <429E2854.1050209@arbash-meinel.com> (raw)
In-Reply-To: <18210.1117657854@sss.pgh.pa.us>
References: <20050601151618.M48325@narrowpathinc.com>
<14825.1117642780@sss.pgh.pa.us>
<20050601200610.M12354@narrowpathinc.com>
<18210.1117657854@sss.pgh.pa.us>
Tom Lane wrote:
...
>Now that I think about it, you were (if I understood your layout
>correctly) proposing to put the xlog on your system's root disk.
>This is probably a bad idea for performance, because there will always
>be other traffic to the root disk. What you are really trying to
>accomplish is to make sure the xlog is on a disk spindle that has no
>other traffic besides xlog, so that the disk heads never have to move
>off the current xlog file. The xlog traffic is 100% sequential writes
>and so you can cut the seeks involved to near nil if you can dedicate
>a spindle to it.
>
>
I certainly agree with what you wrote. But my understanding is that if
you only have 2 arrays, then moving xlog onto the array not on the
database is better than having it with the database. It isn't optimum,
but it is better. Because that way there isn't as much contention
between the database and xlog.
John
=:->
Attachments:
signature.asc (application/pgp-signature, 252B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: john@arbash-meinel.com, tgl@sss.pgh.pa.us
Subject: Re: Moving pg_xlog
In-Reply-To: <429E2854.1050209@arbash-meinel.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox