# 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: # # postgresql-cstore_fdw/ # postgresql-cstore_fdw/pkg-descr # postgresql-cstore_fdw/pkg-plist # postgresql-cstore_fdw/Makefile # postgresql-cstore_fdw/distinfo # echo c - postgresql-cstore_fdw/ mkdir -p postgresql-cstore_fdw/ > /dev/null 2>&1 echo x - postgresql-cstore_fdw/pkg-descr sed 's/^X//' >postgresql-cstore_fdw/pkg-descr << '960dfd885c8dbad7372e7215cd6ef91a' 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 960dfd885c8dbad7372e7215cd6ef91a echo x - postgresql-cstore_fdw/pkg-plist sed 's/^X//' >postgresql-cstore_fdw/pkg-plist << '06e2fc85eff0e2b08d2ffb871a7493c6' 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 06e2fc85eff0e2b08d2ffb871a7493c6 echo x - postgresql-cstore_fdw/Makefile sed 's/^X//' >postgresql-cstore_fdw/Makefile << '95c61727a97635b3025abca34a316ec5' X# Created by: Jov 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 XUSES= gmake pgsql:9.3+ XUSE_GITHUB= yes XGH_ACCOUNT= citusdata X XWANT_PGSQL= server X X.include 95c61727a97635b3025abca34a316ec5 echo x - postgresql-cstore_fdw/distinfo sed 's/^X//' >postgresql-cstore_fdw/distinfo << 'e87c7cce6743dda49345b09b01e6a370' XTIMESTAMP = 1496052817 XSHA256 (citusdata-cstore_fdw-v1.5.1_GH0.tar.gz) = dd1b6884ab9b21a6a90461df53d1ab7336fec4c4ff3073ee0a916b0bcbb5a44c XSIZE (citusdata-cstore_fdw-v1.5.1_GH0.tar.gz) = 87684 e87c7cce6743dda49345b09b01e6a370 exit