Re: Postgres vs other Postgres based MPP implementations

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