From owner-svn-ports-head@freebsd.org Tue Jun 13 10:28:32 2017 Return-Path: Delivered-To: svn-ports-head@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 6085ABF0435; Tue, 13 Jun 2017 10:28:32 +0000 (UTC) (envelope-from tz@FreeBSD.org) Received: from repo.freebsd.org (repo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:0]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 3B16476106; Tue, 13 Jun 2017 10:28:32 +0000 (UTC) (envelope-from tz@FreeBSD.org) Received: from repo.freebsd.org ([127.0.1.37]) by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id v5DASVHM024305; Tue, 13 Jun 2017 10:28:31 GMT (envelope-from tz@FreeBSD.org) Received: (from tz@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id v5DASUMv024300; Tue, 13 Jun 2017 10:28:30 GMT (envelope-from tz@FreeBSD.org) Message-Id: <201706131028.v5DASUMv024300@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: tz set sender to tz@FreeBSD.org using -f From: Torsten Zuehlsdorff Date: Tue, 13 Jun 2017 10:28:30 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r443496 - in head/databases: . postgresql-cstore_fdw X-SVN-Group: ports-head MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-BeenThere: svn-ports-head@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: SVN commit messages for the ports tree for head List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 13 Jun 2017 10:28:32 -0000 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 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 +# $FreeBSD$ + +PORTNAME= cstore_fdw +PORTVERSION= 1.5.1 +DISTVERSIONPREFIX= v +CATEGORIES= databases +PKGNAMEPREFIX= postgresql${PGSQL_VER:S/.//}- + +MAINTAINER= amutu@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 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