importance of fast disks with pg

Поиск
Список
Период
Сортировка
От Thomas Finneid
Тема importance of fast disks with pg
Дата
Msg-id 469D382E.6030603@ifi.uio.no
обсуждение исходный текст
Ответы Re: importance of fast disks with pg  (Dan Harris <fbsd@drivefaster.net>)
Re: importance of fast disks with pg  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-performance
Hi

During the somes I did I noticed that it does not necessarily seem to be
true that one needs the fastest disks to have a pg system that is fast.

It seems to me that its more important to:
- choose the correct methods to use for the operation
- tune the pg memory settings
- tune/disable pg xlog/wal etc

It also seems to me that fast disks are more important for db systems of
the OLTP type applications with real concurrency of both readers and
writes across many, possibly larger, tables etc.

Are the above statements close to having any truth in them?

regards

thomas

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

Предыдущее
От: Thomas Finneid
Дата:
Сообщение: Re: insert vs select into performance
Следующее
От: Dan Harris
Дата:
Сообщение: Re: importance of fast disks with pg