| Port details |
- postgresql-cstore_fdw Columnar store for analytics with PostgreSQL
- 1.7.0 databases
 =1      Version of this port present on the latest quarterly branch. - Maintainer: farrokhi@FreeBSD.org
- Port Added: 2017-06-13 10:28:39
- Last Update: 2022-07-20 14:21:07
- Commit Hash: d076ad9
- People watching this port, also watch:: json-c, sysinfo, python, miller
- License: APACHE20
- Description:
- 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 : git : Homepage
- pkg-plist: as obtained via:
make generate-plist - Dependency lines:
-
- postgresql13-cstore_fdw>0:databases/postgresql-cstore_fdw
- To install the port:
- cd /usr/ports/databases/postgresql-cstore_fdw/ && make install clean
- To add the package, run one of these commands:
- pkg install databases/postgresql-cstore_fdw
- pkg install postgresql13-cstore_fdw
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.- PKGNAME: postgresql13-cstore_fdw
- Flavors: there is no flavor information for this port.
- distinfo:
- TIMESTAMP = 1633795109
SHA256 (citusdata-cstore_fdw-v1.7.0_GH0.tar.gz) = bd8a06654b483d27b48d8196cf6baac0c7828b431b49ac097923ac0c54a1c38c
SIZE (citusdata-cstore_fdw-v1.7.0_GH0.tar.gz) = 93313
- Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- gmake>=4.3 : devel/gmake
- postgres : databases/postgresql13-server
- as : devel/binutils
- Runtime dependencies:
-
- postgres : databases/postgresql13-server
- Library dependencies:
-
- libprotobuf-c.so : devel/protobuf-c
- There are no ports dependent upon this port
- Configuration Options:
- No options to configure
- Options name:
- databases_postgresql-cstore_fdw
- USES:
- gmake pgsql:9.3+
- pkg-message:
- If upgrading from < 1.6:
- If you are upgrading cstore_fdw from a version prior to 1.6, you need
to execute the following steps:
- Restart the PostgreSQL server;
- Run ALTER EXTENSION cstore_fdw UPDATE;
Please, visit the following URL for more information:
https://github.com/citusdata/cstore_fdw/blob/master/README.md
- Master Sites:
|
| Commit History - (may be incomplete: see SVNWeb link above for full details) |
| Date | By | Description |
|---|
20 Jul 2022 14:21:07
  1.7.0 |
Tobias C. Berner (tcberner) |
databases: remove 'Created by' lines
A big Thank You to the original contributors of these ports:
* "Choe, Cheng-Dae" whitekid
* "Mahdi Mokhtari <mokhi64@gmail.com>"
* "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
* <hvo.pm@xs4all.nl>
* <jsmith@resonatingmedia.com>
* <ports@c0decafe.net>
* Aaron Dalton <aaron@FreeBSD.org>
* Adam Weinberger <adamw@FreeBSD.org>
* Ade Lovett <ade@FreeBSD.org>
* Akinori MUSHA aka knu <knu@idaemons.org>
* Alan Snelson <Alan@Wave2.org> (Only the first 15 lines of the commit message are shown above  ) |
23 Oct 2021 23:30:30
1.7.0 |
Kevin Bowling (kbowling) |
databases/postgresql-cstore_fdw: Fix for pgsql 13
PR: 259028
Approved by: maintainer timeout |
06 Apr 2021 14:31:07
1.7.0 |
Mathieu Arnold (mat) |
Remove # $FreeBSD$ from Makefiles. |
20 Feb 2020 12:15:52
  1.7.0 |
farrokhi |
databases/postgresql-cstore_fdw: Fix plist |
19 Feb 2020 10:16:56
1.7.0 |
farrokhi |
databases/postgresql-cstore_fdw: Update to 1.7.0
- Update to 1.7.0 (PostgreSQL 12 support)
- Pet portlint |
13 Aug 2019 16:01:59
1.6.2_2  |
mat |
Convert to UCL & cleanup pkg-message (categories d) |
26 Jul 2019 20:46:57
1.6.2_2 |
gerald |
Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.
This includes ports
- with USE_GCC=yes or USE_GCC=any,
- with USES=fortran,
- using Mk/bsd.octave.mk which in turn features USES=fortran, and
- with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.
PR: 238330 |
12 Dec 2018 01:35:36
1.6.2_1 |
gerald |
Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.
This includes ports
- with USE_GCC=yes or USE_GCC=any,
- with USES=fortran,
- using Mk/bsd.octave.mk which in turn features USES=fortran, and
- with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.
PR: 231590 |
04 Sep 2018 09:43:57
1.6.2 |
farrokhi |
databases/postgresql-cstore_fdw: Update to 1.6.2 |
07 Aug 2018 14:36:24
1.6.1 |
farrokhi |
databases/postgresql-cstore_fdw: Update to 1.6.1
- Update to 1.6.1
- Take maintainership
Changes: https://github.com/citusdata/cstore_fdw#version-161 |
24 Jun 2018 00:54:27
1.6.0 |
linimon |
Workaround the following problem on aarch64 by setting LLD_UNSAFE=yes:
cc: error: invalid linker name in argument '-fuse-ld=bfd'
Neither emaste nor I can figure out exactly where the offending stanza is
coming in. It will take someone with more knowledge of gmake debug flags,
and possibly the src build infrastructure, to figure it out.
While here, pet portlint.
Approved by: portmgr (tier-2 blanket) |
22 Jun 2018 08:28:00
1.6.0 |
yuri |
Correction to r473019: Revert the unintended change to the 'Created by' headers. |
22 Jun 2018 08:04:39
1.6.0 |
yuri |
Reset MAINTAINER on ports maintained by amutu@amutu.com
Based on the new policy of all maintained ports reset
when maintaner is absent for 3 months.
Bug#226400 for science/py-tensorflow is ignored since 2018-03-06 (3+ months).
portscout database indicates that 48.94% of his ports aren't updated. |
23 Jul 2017 14:47:33
1.6.0 |
dbaio |
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
1.5.1 |
tz |
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> |
As an Amazon Associate I earn from qualifying purchases.