[Bug 219635] [NEW PORT] databases/postgresql95-cstore_fdw: Columnar store for analytics with PostgreSQL

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=219635

            Bug ID: 219635
           Summary: [NEW PORT] databases/postgresql95-cstore_fdw: Columnar
                    store for analytics with PostgreSQL
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: freebsd-ports-bugs at FreeBSD.org
          Reporter: amutu at amutu.com
                CC: bapt at FreeBSD.org

Created attachment 183032
  --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=183032&action=edit
postgresql95-cstore_fdw.shar

Cstore_fdw is a extension of PostgreSQL. This extension uses the Optimized Row
Columnar (ORC) format for its data layout. ORC improves upon the RCFile format
developed at Facebook, and brings the following benefits:
        - Compression: Reduces in-memory and on-disk data size by 2-4x. Can be
          extended to support different codecs.
        - Column projections: Only reads column data relevant to the query. 
          Improves performance for I/O bound queries.
        - Skip indexes: Stores min/max statistics for row groups, and uses them
          to skip over unrelated rows.
Further, cstore_fdw used the Postgres foreign data wrapper APIs and type
representations with this extension. This brings:
        - Support for 40+ Postgres data types. The user can also create new
types
          and use them.
        - Statistics collection. PostgreSQL's query optimizer uses these stats
to
          evaluate different query plans and pick the best one.
        - Simple setup. Create foreign table and copy data. Run SQL.

WWW: https://github.com/citusdata/cstore_fdw

-- 
You are receiving this mail because:
You are the assignee for the bug.