Hi, >> 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.
I didn't say OLTP. Our workload is "aggregations/drill downs/roll ups/... " (= OLAP) but we need OLTP like performance i.e. our users are not keen to wait more than several seconds for the result. Greenplum or Postgres + Fusion IO can deliver this performance for us. -- Ondrej Ivanic (ondrej.iva...@gmail.com) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
