Skip site navigation (1) Skip section navigation (2)

Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Olivier Andreotti" <olivier(dot)andreotti(at)gmail(dot)com>
Cc: "Mikael Carneholm" <Mikael(dot)Carneholm(at)wirelesscar(dot)com>, jean-paul(at)argudo(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2
Date: 2006-05-19 13:10:20
Message-ID: 28304.1148044220@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"Olivier Andreotti" <olivier(dot)andreotti(at)gmail(dot)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

In response to

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2006-05-19 20:16:01
Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle
Previous:From: Olivier AndreottiDate: 2006-05-19 10:24:35
Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group