Re: Postgres vs other Postgres based MPP implementations
От | John R Pierce |
---|---|
Тема | Re: Postgres vs other Postgres based MPP implementations |
Дата | |
Msg-id | 4EB8D6FC.6040205@hogranch.com обсуждение исходный текст |
Ответ на | Re: Postgres vs other Postgres based MPP implementations (Ondrej Ivanič <ondrej.ivanic@gmail.com>) |
Ответы |
Re: Postgres vs other Postgres based MPP implementations
|
Список | pgsql-general |
On 11/07/11 10:49 PM, Ondrej Ivanič wrote: > mostly heavy read > workloads but OLTP performance is required (like run query over 100m+ > dataset in 15 sec) that isn't OLTP, its OLAP. Online Analytic Processing rather than Online Transaction Processing.... large complex reporting queries that have to aggregate many rows is classic OLAP. OLTP transactions tend to refer to a few rows at a time of a bunch of tables, and update a few rows of a various tables, and you execute many of them per second, often for a large number of concurrent clients. classic example is a web store system (adding/modifying items in a shopping cart, then purchasing the items in the cart). -- john r pierce N 37, W 122 santa cruz ca mid-left coast
В списке pgsql-general по дате отправления: