two disks - best way to use them?

Поиск
Список
Период
Сортировка
От Rick Schumeyer
Тема two disks - best way to use them?
Дата
Msg-id 00fb01c5f772$59471410$0200a8c0@dell8200
обсуждение исходный текст
Ответы Re: two disks - best way to use them?  (Ron <rjpeace@earthlink.net>)
Re: two disks - best way to use them?  (Olleg Samoylov <olleg_s@mail.ru>)
Список 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 по дате отправления:

Предыдущее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: Open request for benchmarking input (fwd)
Следующее
От: Josep Maria Pinyol Fontseca
Дата:
Сообщение: Re: Network permormance under windows