From: Rick Schumeyer <rschumeyer@ieee.org>
To: pgsql-performance@postgresql.org
Subject: two disks - best way to use them?
Date: Fri, 2 Dec 2005 13:58:13 -0500
Message-ID: <00fb01c5f772$59471410$0200a8c0@dell8200> (raw)
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rschumeyer@ieee.org
Subject: Re: two disks - best way to use them?
In-Reply-To: <00fb01c5f772$59471410$0200a8c0@dell8200>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox