From: Tom Lane <tgl@sss.pgh.pa.us>
To: Olivier Andreotti <olivier.andreotti@gmail.com>
Cc: Mikael Carneholm <Mikael.Carneholm@wirelesscar.com>
Cc: jean-paul@argudo.org
Cc: pgsql-performance@postgresql.org
Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2
Date: Fri, 19 May 2006 09:10:20 -0400
Message-ID: <28304.1148044220@sss.pgh.pa.us> (raw)
In-Reply-To: <d5d40b330605190324u4fd26a80v25bd269bafdcc367@mail.gmail.com>
References: <7F10D26ECFA1FB458B89C5B4B0D72C2B459FFB@sesrv12.wirelesscar.com>
<13688.1147963700@sss.pgh.pa.us>
<d5d40b330605190324u4fd26a80v25bd269bafdcc367@mail.gmail.com>
"Olivier Andreotti" <olivier.andreotti@gmail.com> writes:
> Just a last question about the pg_xlog : i understand that the
> directory must be moved but i have just 3 disks for the database :
> disk 1 and 2 for the data, disk 3 for the indexes, where can i put the
> pg_xlog ?
If you have three disks then put the xlog on one of them and everything
else on the other two. Separating out the indexes is way less important
than getting xlog onto its very own spindle (at least for
write-intensive cases).
regards, tom lane
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: tgl@sss.pgh.pa.us, olivier.andreotti@gmail.com, Mikael.Carneholm@wirelesscar.com, jean-paul@argudo.org
Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2
In-Reply-To: <28304.1148044220@sss.pgh.pa.us>
* 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