On 09/20/2011 03:48 PM, Juan Bru wrote:
Hi,
Is there any plan to develop a PostgreSQL Columnar release?
I'm a researcher in the scope of Health (computer scientist, DBA
background), used to work very well with PostgrSQL. Recently I'm
facing analysis on 100M record tables so a columnar database could be
a better option, but I would like to stay using postgreSQL.
To what extent would your needs be satisfied by a covering index or
index-oriented table?
That is: Are you doing deep data mining where you have LOTS of different
columns you're interested in finding patterns in, or do you only have a
few important columns you need to retrieve most of the time, plus a lot
of less-used data?
--
Craig Ringer
