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.

non port: databases/postgresql-cstore_fdw/pkg-plist

Number of commits found: 3

Thursday, 20 Feb 2020
12:15 farrokhi search for other commits by this committer
databases/postgresql-cstore_fdw: Fix plist
Original commitRevision:526568 
Sunday, 23 Jul 2017
14:47 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]
Original commitRevision:446487 
Tuesday, 13 Jun 2017
10:28 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>
Original commitRevision:443496 

Number of commits found: 3