two disks - best way to use them? - Mailing list pgsql-performance

From Rick Schumeyer
Subject two disks - best way to use them?
Date
Msg-id 00fb01c5f772$59471410$0200a8c0@dell8200
Whole thread Raw
Responses Re: two disks - best way to use them?
Re: two disks - best way to use them?
List pgsql-performance

I installed another drive in my linux pc in an attempt to improve performance

on a large COPY to a table with a geometry index.

 

Based on previous discussion, it seems there are three things competing for the hard

drive:

 

1)       the input data file

2)       the pg table

3)       the WAL

 

What is the best way to distribute these among two drives?  From Tom’s comments

I would think that the pg table and the WAL should be separate.  Does it matter where

the input data is?

pgsql-performance by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: Open request for benchmarking input (fwd)
Next
From: Josep Maria Pinyol Fontseca
Date:
Subject: Re: Network permormance under windows