Re: What exactly is postgres doing during INSERT/UPDATE ?

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: What exactly is postgres doing during INSERT/UPDATE ?
Дата
Msg-id f67928030908310824n1f06cc7wf47a4755513d1a9f@mail.gmail.com
обсуждение исходный текст
Ответ на Re: What exactly is postgres doing during INSERT/UPDATE ?  (Joseph S <jks@selectacast.net>)
Ответы Re: What exactly is postgres doing during INSERT/UPDATE ?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
Дерево обсуждения
On Sun, Aug 30, 2009 at 1:01 PM, Joseph S <jks@selectacast.net> wrote:
I've already learned my lesson and will never use raid 5 again.  The question is what I do with my 14 drives. Should I use only 1 pair for indexes or should I use 4 drives?  The wal logs are already slated for an SSD.



Why not just spread all your index data over 14 spindles, and do the same with your table data?  I haven't encountered this debate in in the pgsql world, but from the Oracle world it seems to me the "Stripe And Mirror Everything" people had the better argument than the "separate tables and indexes" people.


Jeff

В списке pgsql-performance по дате отправления:

Предыдущее
От: Aidan Van Dyk
Дата:
Сообщение: Re: What exactly is postgres doing during INSERT/UPDATE ?
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: What exactly is postgres doing during INSERT/UPDATE ?