| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-05-19 20:16:01 | Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle |
| Previous Message | Olivier Andreotti | 2006-05-19 10:24:35 | Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2 |