notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)

Things are slow!

Some of the pages ont the website are slow. I know diskio is way up. I don't know what it is but it's been going on for about three weeks. It might have been a change to the zpool recordsize on the PostgreSQL database dataset.

One way to know: copy the dataset to another dataset with the original recordsize and use that. I hope can get to that later this week.

I have not tackled the issue yet because I've been concentrating on the BSDCan and PGCon calls for papers.

Port details
postgresql-cstore_fdw Columnar store for analytics with PostgreSQL
1.6.2_2 databases on this many watch lists=1 search for ports that depend on this port Find issues related to this port Report an issue related to this port 1.6.2Version of this port present on the latest quarterly branch.
Maintainer: farrokhi@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2017-06-13 10:28:39
Last Update: 2019-08-13 17:01:59
SVN Revision: 508835
License: APACHE20
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (12 items)
  1. /usr/local/share/licenses/postgresql95-cstore_fdw-1.6.2_2/catalog.mk
  2. /usr/local/share/licenses/postgresql95-cstore_fdw-1.6.2_2/LICENSE
  3. /usr/local/share/licenses/postgresql95-cstore_fdw-1.6.2_2/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.sql
  12. share/postgresql/extension/cstore_fdw.control
Collapse this list.
Dependency lines:
  • postgresql95-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: pkg install postgresql95-cstore_fdw
PKGNAME: postgresql95-cstore_fdw
Flavors: there is no flavor information for this port.
distinfo:

Dependencies
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

USES:

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

Number of commits found: 10

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
13 Aug 2019 16:01:59
Original commit files touched by this commit  1.6.2_2
Revision:508835  Sanity Test Failure
mat search for other commits by this committer
Convert to UCL & cleanup pkg-message (categories d)
26 Jul 2019 20:46:57
Original commit files touched by this commit  1.6.2_2
Revision:507372
gerald search for other commits by this committer
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
Original commit files touched by this commit  1.6.2_1
Revision:487272
gerald search for other commits by this committer
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
Original commit files touched by this commit  1.6.2
Revision:478941
farrokhi search for other commits by this committer
databases/postgresql-cstore_fdw: Update to 1.6.2
07 Aug 2018 14:36:24
Original commit files touched by this commit  1.6.1
Revision:476601
farrokhi search for other commits by this committer
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
Original commit files touched by this commit  1.6.0
Revision:473169
linimon search for other commits by this committer
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
Original commit files touched by this commit  1.6.0
Revision:473023
yuri search for other commits by this committer
Correction to r473019: Revert the unintended change to the 'Created by' headers.
22 Jun 2018 08:04:39
Original commit files touched by this commit  1.6.0
Revision:473019
yuri search for other commits by this committer
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
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: 10

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?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
gitlab-ceDec 10
libidn2*Dec 10
ghostscript9-agpl-baseDec 09
ghostscript9-agpl-x11Dec 09
drm-current-kmod*Dec 04
drm-devel-kmod*Dec 04
drm-fbsd11.2-kmod*Dec 04
drm-fbsd12.0-kmod*Dec 04
py-django21Dec 03
py-django22Dec 03
gitlab-ceNov 28
py-matrix-synapseNov 28
gitlab-ceNov 27
webkit2-gtk3Nov 27
py-urllib3Nov 26

10 vulnerabilities affecting 52 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2019-12-10 21:08:49


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 38223
Broken 736
Deprecated 134
Ignore 1005
Forbidden 3
Restricted 155
No CDROM 72
Vulnerable 27
Expired 6
Set to expire 103
Interactive 0
new 24 hours 4
new 48 hours10
new 7 days34
new fortnight62
new month139

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