From 6205b2464def3845e323ffe3d51ecd2be114a55a Mon Sep 17 00:00:00 2001 From: Torsten Zuehlsdorff Date: Tue, 13 Jun 2017 10:28:30 +0000 Subject: New port: databases/postgresql-cstore_fdw 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 PR: 219635 Submitted by: Jov --- databases/postgresql-cstore_fdw/pkg-plist | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 databases/postgresql-cstore_fdw/pkg-plist (limited to 'databases/postgresql-cstore_fdw/pkg-plist') diff --git a/databases/postgresql-cstore_fdw/pkg-plist b/databases/postgresql-cstore_fdw/pkg-plist new file mode 100644 index 000000000000..8bb7180a7152 --- /dev/null +++ b/databases/postgresql-cstore_fdw/pkg-plist @@ -0,0 +1,8 @@ +lib/postgresql/cstore_fdw.so +share/postgresql/extension/cstore_fdw--1.0--1.1.sql +share/postgresql/extension/cstore_fdw--1.1--1.2.sql +share/postgresql/extension/cstore_fdw--1.2--1.3.sql +share/postgresql/extension/cstore_fdw--1.3--1.4.sql +share/postgresql/extension/cstore_fdw--1.4--1.5.sql +share/postgresql/extension/cstore_fdw--1.5.sql +share/postgresql/extension/cstore_fdw.control -- cgit v1.2.3