# This is a shell archive. Save it in a file, remove anything before # this line, and then unpack it by entering "sh file". Note, it may # create directories; files and directories will be owned by you and # have default permissions. # # This archive contains: # # postgresql95-cstore_fdw # postgresql95-cstore_fdw/pkg-descr # postgresql95-cstore_fdw/pkg-plist # postgresql95-cstore_fdw/Makefile # postgresql95-cstore_fdw/distinfo # echo c - postgresql95-cstore_fdw mkdir -p postgresql95-cstore_fdw > /dev/null 2>&1 echo x - postgresql95-cstore_fdw/pkg-descr sed 's/^X//' >postgresql95-cstore_fdw/pkg-descr << 'a847ce9d608387c84a60a11888cfedc4' XCstore_fdw is a extension of PostgreSQL. This extension uses the Optimized Row XColumnar (ORC) format for its data layout. ORC improves upon the RCFile format Xdeveloped at Facebook, and brings the following benefits: X - Compression: Reduces in-memory and on-disk data size by 2-4x. Can be X extended to support different codecs. X - Column projections: Only reads column data relevant to the query. X Improves performance for I/O bound queries. X - Skip indexes: Stores min/max statistics for row groups, and uses them X to skip over unrelated rows. XFurther, cstore_fdw used the Postgres foreign data wrapper APIs and type Xrepresentations with this extension. This brings: X - Support for 40+ Postgres data types. The user can also create new types X and use them. X - Statistics collection. PostgreSQL's query optimizer uses these stats to X evaluate different query plans and pick the best one. X - Simple setup. Create foreign table and copy data. Run SQL. X XWWW: https://github.com/citusdata/cstore_fdw a847ce9d608387c84a60a11888cfedc4 echo x - postgresql95-cstore_fdw/pkg-plist sed 's/^X//' >postgresql95-cstore_fdw/pkg-plist << '648bc8212d8391b2e5e52be9876dcb62' Xlib/postgresql/cstore_fdw.so Xshare/postgresql/extension/cstore_fdw--1.0--1.1.sql Xshare/postgresql/extension/cstore_fdw--1.1--1.2.sql Xshare/postgresql/extension/cstore_fdw--1.2--1.3.sql Xshare/postgresql/extension/cstore_fdw--1.3--1.4.sql Xshare/postgresql/extension/cstore_fdw--1.4--1.5.sql Xshare/postgresql/extension/cstore_fdw--1.5.sql Xshare/postgresql/extension/cstore_fdw.control 648bc8212d8391b2e5e52be9876dcb62 echo x - postgresql95-cstore_fdw/Makefile sed 's/^X//' >postgresql95-cstore_fdw/Makefile << '1056e6ac86d68d634a6eef90407f72e3' X# Created by: Jov amutu@amutu.com X# $FreeBSD$ X XPORTNAME= cstore_fdw XPORTVERSION= 1.5.1 XDISTVERSIONPREFIX= v XCATEGORIES= databases XPKGNAMEPREFIX= postgresql${PGSQL_VER:S/.//}- X XMAINTAINER= amutu@amutu.com XCOMMENT= Columnar store for analytics with PostgreSQL X XLICENSE= PostgreSQL X XLIB_DEPENDS= libprotobuf-c.so:devel/protobuf-c X XPGSQL_VER?= 9.5 XUSES= gmake pgsql:${PGSQL_VER} XUSE_GITHUB= yes XGH_ACCOUNT= citusdata X X.include 1056e6ac86d68d634a6eef90407f72e3 echo x - postgresql95-cstore_fdw/distinfo sed 's/^X//' >postgresql95-cstore_fdw/distinfo << 'edf82ede48953dc5d02e0e8323dc4916' XTIMESTAMP = 1496052817 XSHA256 (citusdata-cstore_fdw-v1.5.1_GH0.tar.gz) = dd1b6884ab9b21a6a90461df53d1ab7336fec4c4ff3073ee0a916b0bcbb5a44c XSIZE (citusdata-cstore_fdw-v1.5.1_GH0.tar.gz) = 87684 edf82ede48953dc5d02e0e8323dc4916 exit