| Port details |
- postgresql-cstore_fdw Columnar store for analytics with PostgreSQL
- 1.7.0 databases
 =3      1.7.0Version of this port present on the latest quarterly branch. - Maintainer: farrokhi@FreeBSD.org
- Port Added: 2017-06-13 10:28:39
- Last Update: 2023-08-30 19:31:10
- Commit Hash: 209a16c
- People watching this port, also watch:: nagios-check_hdd_health, nuitka-py311, monit, py39-beautifulsoup, openmdns
- License: APACHE20
- WWW:
- https://github.com/citusdata/cstore_fdw
- 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.
  ¦  ¦  ¦  ¦ 
- Manual pages:
- FreshPorts has no man page information for this port.
- 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:11-13
- 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: for full details, see links to repositories near top of page) |
| Commit | Credits | Log message |
|---|
1.7.0
30 Aug 2023 19:31:10
 |
Kevin Bowling (kbowling) |
databases/postgresql-cstore_fdw: Mark PostgreSQL 13 as max version
PR: 273058 |
1.7.0
15 Apr 2023 13:14:58
|
Muhammad Moinur Rahman (bofh) |
*/*: Remove pointers to EOLed pgsql versions
- Remove dotted pgsql versions
Approved by: portmgr |
07 Sep 2022 21:58:51
|
Stefan Eßer (se) |
Remove WWW entries moved into port Makefiles
Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.
This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.
Approved by: portmgr (tcberner) |
1.7.0
07 Sep 2022 21:10:59
|
Stefan Eßer (se) |
Add WWW entries to port Makefiles
It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.
Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.
There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above  ) |
1.7.0
20 Jul 2022 14:21:07
|
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 ) |
1.7.0
23 Oct 2021 23:30:30
|
Kevin Bowling (kbowling) |
databases/postgresql-cstore_fdw: Fix for pgsql 13
PR: 259028
Approved by: maintainer timeout |
1.7.0
06 Apr 2021 14:31:07
|
Mathieu Arnold (mat) |
Remove # $FreeBSD$ from Makefiles. |
1.7.0
20 Feb 2020 12:15:52
 |
farrokhi |
databases/postgresql-cstore_fdw: Fix plist |
1.7.0
19 Feb 2020 10:16:56
|
farrokhi |
databases/postgresql-cstore_fdw: Update to 1.7.0
- Update to 1.7.0 (PostgreSQL 12 support)
- Pet portlint |
1.6.2_2
13 Aug 2019 16:01:59
 |
mat |
Convert to UCL & cleanup pkg-message (categories d) |
1.6.2_2
26 Jul 2019 20:46:57
|
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 |
1.6.2_1
12 Dec 2018 01:35:36
|
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 |
1.6.2
04 Sep 2018 09:43:57
|
farrokhi |
databases/postgresql-cstore_fdw: Update to 1.6.2 |
1.6.1
07 Aug 2018 14:36:24
|
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 |
1.6.0
24 Jun 2018 00:54:27
|
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) |
1.6.0
22 Jun 2018 08:28:00
|
yuri |
Correction to r473019: Revert the unintended change to the 'Created by' headers. |
1.6.0
22 Jun 2018 08:04:39
|
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. |
1.6.0
23 Jul 2017 14:47:33
|
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] |
1.5.1
13 Jun 2017 10:28:30
|
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.