Postgres Pro
Downloads
Home   >   mailing lists

Data and logs on different physical drives - advantage? - Mailing list pgsql-admin

From Weber, Johann (ISS Kassel)
Subject Data and logs on different physical drives - advantage?
Date
Msg-id B8ADDBDA8696F546BDAC69B469D7F0511DABE9@kasmaiexcp01.iss.net
Whole thread Raw
Responses Re: Data and logs on different physical drives - advantage?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
I learned for other database systems, that it is an advantage to have database on one physical drive and transaction logs on a different physical drive, as this should minimize seeks on the hard-disks.
 
Is this true for PostgreSQL (V 8.0 on ReadHat)? My tests do not show any speed gained when placing pg_clog and pg_xlog on a different drive.
 

pgsql-admin by date:

Previous
From: Gary Stainburn
Date:
Subject: Update - pg_dumpall money problem
Next
From: Hannes Dorbath
Date:
Subject: Re: Update - pg_dumpall money problem