Performance suggestions for an update-mostly database?

Поиск
Список
Период
Сортировка
От Steve Atkins
Тема Performance suggestions for an update-mostly database?
Дата
Msg-id 20041004174019.GA25671@gp.word-to-the-wise.com
обсуждение исходный текст
Ответы Re: Performance suggestions for an update-mostly database?
Список pgsql-performance
I'm putting together a system where the operation mix is likely to be
>95% update, <5% select on primary key.

I'm used to performance tuning on a select-heavy database, but this
will have a very different impact on the system. Does anyone have any
experience with an update heavy system, and have any performance hints
or hardware suggestions?

Cheers,
  Steve

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

Предыдущее
От: Patrick Hatcher
Дата:
Сообщение: Re: Slow update/insert process
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Performance suggestions for an update-mostly database?