Re: COLUMNAR postgreSQL ?

Craig Ringer <ringerc@xxxxxxxxxxxxx> · Tue, 20 Sep 2011 18:58:55 +0800



    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