Re: Benchmarck PostgreSQL 8.1.4 MySQL 5.0.20 and Oracle 10g2

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Olivier Andreotti" <olivier.andreotti@xxxxxxxxx> 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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux