two disks - best way to use them?

From: "Rick Schumeyer" <rschumeyer(at)ieee(dot)org>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: two disks - best way to use them?
Date: 2005-12-02 18:58:13
Message-ID: 00fb01c5f772$59471410$0200a8c0@dell8200
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ron 2005-12-02 20:05:30 Re: two disks - best way to use them?
Previous Message Josep Maria Pinyol Fontseca 2005-12-02 17:24:07 Re: Network permormance under windows