When does sequential performance matter in PG?

Список
Период
Сортировка
От henk de wit
Тема When does sequential performance matter in PG?
Дата
Msg-id COL104-W4301D2DDC445A99E55E086F5A10@phx.gbl
обсуждение исходный текст
Ответы Re: When does sequential performance matter in PG?  (Matthew Wakeling)
Re: When does sequential performance matter in PG?  (Greg Smith)
Список pgsql-performance
Дерево обсуждения
When does sequential performance matter in PG?  (henk de wit, )
 Re: When does sequential performance matter in PG?  (Matthew Wakeling, )
  Re: When does sequential performance matter in PG?  (henk de wit, )
  Re: When does sequential performance matter in PG?  (Scott Carey, )
 Re: When does sequential performance matter in PG?  (Greg Smith, )
Hi,

It is frequently said that for PostgreSQL the number 1 thing to pay attention to when increasing performance is the amount of IOPS a storage system is capable of. Now I wonder if there is any situation in which sequential IO performance comes into play. E.g. perhaps during a tablescan on a non-fragmented table, or during a backup or restore?

The reason I'm asking is that we're building a storage array and for some reason are unable to increase the number of random IOPS beyond a certain threshold when we add more controllers or more (SSD) disks to the system. However, the sequential performance keeps increasing when we do that.

Would this extra sequential performance be of any benefit to PG or would it just be wasted?

Kind regards


Express yourself instantly with MSN Messenger! MSN Messenger

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

Предыдущее
От: Scott Carey
Дата:
Сообщение: Re: When does sequential performance matter in PG?
Следующее
От: "Steve McLellan"
Дата:
Сообщение: Query performance over a large proportion of data