heavly load system spec

Поиск
Список
Период
Сортировка
От Gregg Jaskiewicz
Тема heavly load system spec
Дата
Msg-id CAJY59_jeC1r5LYOk05UiL5BE+C=WQAVD17+LU93q2CLSvh4Umg@mail.gmail.com
обсуждение исходный текст
Ответы Re: heavly load system spec  (Robert Haas <robertmhaas@gmail.com>)
Re: heavly load system spec  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-performance
I know this is a very general question. But if you guys had to specify
system (could be one server or cluster), with sustainable transaction
rate of 1.5M tps running postgresql, what configuration and hardware
would you be looking for ?
The transaction distribution there is 90% writes/updates and 10% reads.
We're talking 64 linux, Intel/IBM system.

I'm trying to see how that compares with Oracle system.

Thanks.

--
GJ

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: bad planning with 75% effective_cache_size