notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)Want a good monitor light? See my photosAll times are UTC		 Ukraine

Bot filter coming soon

To deter bots pegging the database CPU to 100%, a bot testing filter to be added to the website. This should not affect newsfeeds etc. Anubis seems light-weight - it is already in use within the FreeBSD Project. This notice is just a heads up in case you see something odd. This notice will be updated after Anubis is installed.

Port details on branch 2025Q3
postgresql-cstore_fdw Columnar store for analytics with PostgreSQL
1.7.0_1 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 View this port on Repology. pkg-fallout 1.7.0_1Version of this port present on the latest quarterly branch.
Maintainer: farrokhi@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2025-07-09 10:54:09
Last Update: 2025-07-09 10:50:07
Commit Hash: 71cd095
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.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (16 items)
Collapse this list.
  1. /usr/local/share/licenses/postgresql13-cstore_fdw-1.7.0_1/catalog.mk
  2. /usr/local/share/licenses/postgresql13-cstore_fdw-1.7.0_1/LICENSE
  3. /usr/local/share/licenses/postgresql13-cstore_fdw-1.7.0_1/APACHE20
  4. lib/postgresql/cstore_fdw.so
  5. share/postgresql/extension/cstore_fdw--1.0--1.1.sql
  6. share/postgresql/extension/cstore_fdw--1.1--1.2.sql
  7. share/postgresql/extension/cstore_fdw--1.2--1.3.sql
  8. share/postgresql/extension/cstore_fdw--1.3--1.4.sql
  9. share/postgresql/extension/cstore_fdw--1.4--1.5.sql
  10. share/postgresql/extension/cstore_fdw--1.5--1.6.sql
  11. share/postgresql/extension/cstore_fdw--1.6--1.7.sql
  12. share/postgresql/extension/cstore_fdw--1.7.sql
  13. share/postgresql/extension/cstore_fdw.control
  14. @owner
  15. @group
  16. @mode
Collapse this list.
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

Expand this list (2 items)

Collapse this list.

SHA256 (2b6bf67ca60faf5a3ebe914fad53257a634ae48a.patch) = 5a396090cb99ae6af5774c65ed4e1d5e0f249b79e8d734624688fee174bd73d5 SIZE (2b6bf67ca60faf5a3ebe914fad53257a634ae48a.patch) = 16786

Collapse this list.

No package information for this port in our database
Sometimes this happens. Not all ports have packages. Perhaps there is a build error. Check the fallout link: pkg-fallout
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake>=4.4.1 : devel/gmake
  2. postgres : databases/postgresql13-server
  3. as : devel/binutils
Runtime dependencies:
  1. postgres : databases/postgresql13-server
Library dependencies:
  1. 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:
Expand this list (1 items)
Collapse this list.
  1. https://codeload.github.com/citusdata/cstore_fdw/tar.gz/v1.7.0?dummy=/
Collapse this list.

Number of commits found: 1

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
1.7.0_1
09 Jul 2025 10:50:07
commit hash: 71cd095745ec97ac0167033665062407fd7b154fcommit hash: 71cd095745ec97ac0167033665062407fd7b154fcommit hash: 71cd095745ec97ac0167033665062407fd7b154fcommit hash: 71cd095745ec97ac0167033665062407fd7b154f files touched by this commit		 Don Lewis (truckman) search for other commits by this committer 
*/*: Bump PORTREVISION for devel/protobuf-c update

libprotobuf-c.so once again has version info.  Force a rebuild of
its consumers.

PR:		282060
MFH:		2025Q3
Sponsored by:	<If the change was sponsored by an organization.>

(cherry picked from commit f0ba732a818fd9e7d0fbcb2c9be128163a3c3b9a)

Number of commits found: 1
Login
User Login
Create account

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

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
Security Policy
Privacy
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
libwasmtimeJul 20
unboundJul 18
libxml2*Jul 15
linux-c7-libxml2*Jul 15
linux-rl9-libxml2*Jul 15
tomcat101*Jul 15
tomcat110*Jul 15
tomcat9*Jul 15
gnutlsJul 14
liboqsJul 14
libxsltJul 12
linux-c7-libxsltJul 12
linux-rl9-libxsltJul 12
apache24Jul 11
gitlabJul 10

20 vulnerabilities affecting 185 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last processed:
2025-07-20 04:36:57 UTC


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)

Calculated hourly:
Port count 33491
Broken 129
Deprecated 235
Ignore 246
Forbidden 0
Restricted 2
No CDROM 1
Vulnerable 37
Expired 20
Set to expire 182
Interactive 0
new 24 hours 10
new 48 hours20
new 7 days47
new fortnight72
new month237
Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD 		Valid HTML, CSS, and RSS. Copyright © 2000-2025 Dan Langille. All rights reserved.