databases/postgresql-cstore_fdw 1.7.0 DragonFly

Columnar store for analytics with PostgreSQL

System: DragonFly
Repository: DPorts
Maintainer: [email protected] (as in FreeBSD)
License: APACHE20
Categories: databases
Package size: 30.8 KiB, 84.7 KiB installed

Description

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.

Install

Binary package:

pkg install postgresql13-cstore_fdw

From DPorts:

cd /usr/dports/databases/postgresql-cstore_fdw && make install clean

Dependencies

Run dependencies 2

No port depends on this one.

Configuration

No options to configure.

Service scripts: none

Message after installing

If you are upgrading cstore_fdw from a version prior to 1.6, you need 
to execute the following steps:

  - Restart the PostgreSQL server;

  - Run ALTER EXTENSION cstore_fdw UPDATE;

Please, visit the following URL for more information:

https://github.com/citusdata/cstore_fdw/blob/master/README.md