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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
