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?