Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2 - Mailing list pgsql-performance

From Tom Lane
Subject Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2
Date
Msg-id 28304.1148044220@sss.pgh.pa.us
Whole thread Raw
In response to Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2  ("Olivier Andreotti" <olivier.andreotti@gmail.com>)
List pgsql-performance
"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

pgsql-performance by date:

Previous
From: "Olivier Andreotti"
Date:
Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle