Re: COLUMNAR postgreSQL ?

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