Date: Mon, 29 May 2017 13:57:07 +0000 From: bugzilla-noreply@freebsd.org To: freebsd-ports-bugs@FreeBSD.org Subject: [Bug 219635] [NEW PORT] databases/postgresql95-cstore_fdw: Columnar store for analytics with PostgreSQL Message-ID: <bug-219635-13@https.bugs.freebsd.org/bugzilla/>
next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D219635 Bug ID: 219635 Summary: [NEW PORT] databases/postgresql95-cstore_fdw: Columnar store for analytics with PostgreSQL Product: Ports & Packages Version: Latest Hardware: Any OS: Any Status: New Severity: Affects Only Me Priority: --- Component: Individual Port(s) Assignee: freebsd-ports-bugs@FreeBSD.org Reporter: amutu@amutu.com CC: bapt@FreeBSD.org Created attachment 183032 --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=3D183032&action= =3Dedit postgresql95-cstore_fdw.shar 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 for= mat 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.= =20 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 st= ats 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 --=20 You are receiving this mail because: You are the assignee for the bug.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-219635-13>