svn commit: r443496 - in head/databases: . postgresql-cstore_fdw

[Torsten Zuehlsdorff]

Author: tz
Date: Tue Jun 13 10:28:30 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 at amutu.com>

Added:
  head/databases/postgresql-cstore_fdw/
  head/databases/postgresql-cstore_fdw/Makefile   (contents, props changed)
  head/databases/postgresql-cstore_fdw/distinfo   (contents, props changed)
  head/databases/postgresql-cstore_fdw/pkg-descr   (contents, props changed)
  head/databases/postgresql-cstore_fdw/pkg-plist   (contents, props changed)
Modified:
  head/databases/Makefile

Modified: head/databases/Makefile
==============================================================================
--- head/databases/Makefile	Tue Jun 13 09:49:12 2017	(r443495)
+++ head/databases/Makefile	Tue Jun 13 10:28:30 2017	(r443496)
@@ -653,6 +653,7 @@
     SUBDIR += postgis21
     SUBDIR += postgis22
     SUBDIR += postgis23
+    SUBDIR += postgresql-cstore_fdw
     SUBDIR += postgresql-jdbc
     SUBDIR += postgresql-libpgeasy
     SUBDIR += postgresql-libpqxx

Added: head/databases/postgresql-cstore_fdw/Makefile
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/postgresql-cstore_fdw/Makefile	Tue Jun 13 10:28:30 2017	(r443496)
@@ -0,0 +1,23 @@
+# Created by: Jov <amutu at amutu.com>
+# $FreeBSD$
+
+PORTNAME=	cstore_fdw
+PORTVERSION=	1.5.1
+DISTVERSIONPREFIX=	v
+CATEGORIES=	databases
+PKGNAMEPREFIX=	postgresql${PGSQL_VER:S/.//}-
+
+MAINTAINER=	amutu at amutu.com
+COMMENT=	Columnar store for analytics with PostgreSQL
+
+LICENSE=	PostgreSQL
+
+LIB_DEPENDS=	libprotobuf-c.so:devel/protobuf-c
+
+USES=		gmake pgsql:9.3+
+USE_GITHUB=	yes
+GH_ACCOUNT=	citusdata
+
+WANT_PGSQL=	server
+
+.include <bsd.port.mk>

Added: head/databases/postgresql-cstore_fdw/distinfo
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/postgresql-cstore_fdw/distinfo	Tue Jun 13 10:28:30 2017	(r443496)
@@ -0,0 +1,3 @@
+TIMESTAMP = 1496052817
+SHA256 (citusdata-cstore_fdw-v1.5.1_GH0.tar.gz) = dd1b6884ab9b21a6a90461df53d1ab7336fec4c4ff3073ee0a916b0bcbb5a44c
+SIZE (citusdata-cstore_fdw-v1.5.1_GH0.tar.gz) = 87684

Added: head/databases/postgresql-cstore_fdw/pkg-descr
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/postgresql-cstore_fdw/pkg-descr	Tue Jun 13 10:28:30 2017	(r443496)
@@ -0,0 +1,18 @@
+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

Added: head/databases/postgresql-cstore_fdw/pkg-plist
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ head/databases/postgresql-cstore_fdw/pkg-plist	Tue Jun 13 10:28:30 2017	(r443496)
@@ -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