Created attachment 183032 [details] 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
Created attachment 183048 [details] postgresql-cstore_fdw.shar make this port depends on the pgsql version user installed.
Created attachment 183089 [details] postgresql-cstore.shar add WANT_PGSQL= server,the USES pgsql:version only add client depend.
A commit references this bug: Author: tz Date: Tue Jun 13 10:28:31 UTC 2017 New revision: 443496 URL: https://svnweb.freebsd.org/changeset/ports/443496 Log: 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 <amutu@amutu.com> Changes: head/databases/Makefile head/databases/postgresql-cstore_fdw/ head/databases/postgresql-cstore_fdw/Makefile head/databases/postgresql-cstore_fdw/distinfo head/databases/postgresql-cstore_fdw/pkg-descr head/databases/postgresql-cstore_fdw/pkg-plist
Committed, thanks! :)