FreshPorts -- The Place For Ports If you buy from Amazon USA, please support us by using this link.
Follow us
Blog
Twitter

Port details
postgresql-cstore_fdw Columnar store for analytics with PostgreSQL
1.6.0 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port
Maintainer: amutu@amutu.com search for ports maintained by this maintainer
Port Added: 13 Jun 2017 10:28:39
License: APACHE20
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
SVNWeb : Homepage : PortsMon

To install the port: cd /usr/ports/databases/postgresql-cstore_fdw/ && make install clean
To add the package: pkg install postgresql95-cstore_fdw

PKGNAME: postgresql95-cstore_fdw

distinfo:

TIMESTAMP = 1500735106
SHA256 (citusdata-cstore_fdw-v1.6.0_GH0.tar.gz) = e95a3ada47b2a0f72f8fb5906c2aa6e0e1d7c4933e4d435943234f85715b48fd
SIZE (citusdata-cstore_fdw-v1.6.0_GH0.tar.gz) = 90853


NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:
  1. gmake : devel/gmake
  2. postgres : databases/postgresql95-server
Runtime dependencies:
  1. postgres : databases/postgresql95-server
Library dependencies:
  1. libprotobuf-c.so : devel/protobuf-c
There are no ports dependent upon this port

Configuration Options
     No options to configure

USES:
gmake pgsql:9.3+

Master Sites:
  1. https://codeload.github.com/citusdata/cstore_fdw/tar.gz/v1.6.0?dummy=/

Number of commits found: 2

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
23 Jul 2017 14:47:33
Original commit files touched by this commit  1.6.0
Revision:446487
dbaio search for other commits by this committer
databases/postgresql-cstore_fdw: Update to 1.6.0

- STRIP cstore_fdw.so [1]
- Update LICENSE
- Add a message about the additional steps for users that are upgrading

PR:		220922 [1]
Submitted by:	amutu@amutu.com (maintainer) [1]
13 Jun 2017 10:28:30
Original commit files touched by this commit  1.5.1
Revision:443496
tz search for other commits by this committer
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>

Number of commits found: 2

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
arjOct 19
cactiOct 19
mariadb100-serverOct 19
mariadb101-serverOct 19
mariadb102-serverOct 19
mariadb55-serverOct 19
mysql55-serverOct 19
mysql56-serverOct 19
mysql57-serverOct 19
percona55-serverOct 19
percona56-serverOct 19
percona57-serverOct 19
krb5Oct 18
krb5-113Oct 18
krb5-114Oct 18

22 vulnerabilities affecting 93 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 31595
Broken 153
Deprecated 60
Ignore 422
Forbidden 0
Restricted 175
No CDROM 78
Vulnerable 58
Expired 16
Set to expire 53
Interactive 0
new 24 hours 13
new 48 hours15
new 7 days25
new fortnight49
new month108

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2017 Dan Langille. All rights reserved.