Port details on branch 2022Q3 |
- postgresql-cstore_fdw Columnar store for analytics with PostgreSQL
- 1.7.0 databases =1 1.7.0Version of this port present on the latest quarterly branch.
- Maintainer: farrokhi@FreeBSD.org
- Port Added: 2017-06-13 10:28:39
- Last Update: 2023-08-30 19:31:10
- Commit Hash: 209a16c
- People watching this port, also watch:: json-c, sysinfo, python, miller
- License: APACHE20
- WWW:
- https://github.com/citusdata/cstore_fdw
- 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.
- ¦ ¦ ¦ ¦
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - Dependency lines:
-
- postgresql13-cstore_fdw>0:databases/postgresql-cstore_fdw
- To install the port:
- cd /usr/ports/databases/postgresql-cstore_fdw/ && make install clean
- To add the package, run one of these commands:
- pkg install databases/postgresql-cstore_fdw
- pkg install postgresql13-cstore_fdw
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.- PKGNAME: postgresql13-cstore_fdw
- Flavors: there is no flavor information for this port.
- distinfo:
- TIMESTAMP = 1633795109
SHA256 (citusdata-cstore_fdw-v1.7.0_GH0.tar.gz) = bd8a06654b483d27b48d8196cf6baac0c7828b431b49ac097923ac0c54a1c38c
SIZE (citusdata-cstore_fdw-v1.7.0_GH0.tar.gz) = 93313
Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- gmake>=4.3 : devel/gmake
- postgres : databases/postgresql13-server
- as : devel/binutils
- Runtime dependencies:
-
- postgres : databases/postgresql13-server
- Library dependencies:
-
- libprotobuf-c.so : devel/protobuf-c
- There are no ports dependent upon this port
Configuration Options:
- No options to configure
- Options name:
- databases_postgresql-cstore_fdw
- USES:
- gmake pgsql:11-13
- pkg-message:
- If upgrading from < 1.6:
- 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
- Master Sites:
|