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.

non port: databases/postgresql-cstore_fdw/pkg-descr
SVNWeb

Number of commits found: 1

Tue, 13 Jun 2017
[ 10:28 tz ] Original commit   Revision:443496
443496 databases/Makefile
443496 databases/postgresql-cstore_fdw
443496 databases/postgresql-cstore_fdw/Makefile
443496 databases/postgresql-cstore_fdw/distinfo
443496 databases/postgresql-cstore_fdw/pkg-descr
443496 databases/postgresql-cstore_fdw/pkg-plist
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: 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?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
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
clamavNov 25
unboundNov 23

9 vulnerabilities affecting 58 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2019-12-09 20:56:56


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 38220
Broken 737
Deprecated 135
Ignore 1006
Forbidden 3
Restricted 155
No CDROM 72
Vulnerable 26
Expired 7
Set to expire 104
Interactive 0
new 24 hours 5
new 48 hours10
new 7 days35
new fortnight62
new month136

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