cstore_fdw
- Ebuilds: 1, Testing: 1.7.0 Description:
Cstore_fdw is an open source columnar store extension for PostgreSQL. Columnar
stores provide notable benefits for analytics use cases where data is loaded
in batches. Cstore_fdw's columnar nature delivers performance by only reading
relevant data from disk, and it may compress data 6x-10x to reduce space
requirements for data archival.
Homepage:https://www.citusdata.com/ License: AGPL-3
hypopg
- Ebuilds: 2, Testing: 1.4.2 Description:
HypoPG is a PostgreSQL extension adding support for hypothetical indexes.
An hypothetical, or virtual, index is an index that doesn't really exists,
and thus doesn't cost CPU, disk or any resource to create. They're useful
to know if specific indexes can increase performance for problematic queries,
since you can know if PostgreSQL will use these indexes or not without
having to spend resources to create them.
Homepage:http://hypopg.github.io/hypopg/ License: Apache-2.0
kafka_fdw
- Ebuilds: 1, Testing: 9999 Description:
At this point the project is not yet production ready. Use with care. Pull requests welcome
A simple foreign data wrapper for Kafka which allows it to be treated as a table.
Currently kafka_fdw allows message parsing in csv and json format. More might come in a future release.
Homepage:https://github.com/adjust/kafka_fdw License: AGPL-3
pg_partman
- Ebuilds: 1, Testing: 4.7.2 Description:
pg_partman is an extension to create and manage both time-based and serial-based table partition sets. Native partitioning in PostgreSQL 10 is supported as of pg_partman v3.0.1. Note that all the features of trigger-based partitioning are not yet supported in native, but performance in both reads and writes is significantly better.
Child table creation is all managed by the extension itself. For non-native, trigger function maintenance is also handled. For non-native partitioning, tables with existing data can have their data partitioned in easily managed smaller batches. For native partitioning, the creation of a new partitioned set is required and data will have to be migrated over separately.
Optional retention policy can automatically drop partitions no longer needed for both native and non-native partitioning.
A background worker (BGW) process is included to automatically run partition maintenance without the need of an external scheduler (cron, etc) in most cases.
All bug reports, feature requests and general questions can be directed to the Issues section on Github. Please feel free to post here no matter how minor you may feel your issue or question may be. - https://github.com/keithf4/pg_partman/issues
If you're looking for a partitioning system that handles any range type beyond just time and serial, the new native partitioning features in PostgreSQL 10 are likely the best method for the foreseeable future. If this is something critical to your environment, start planning your upgrades now!
Homepage:https://github.com/keithf4/pg_partman License: BSD
pg_qualstats
- Ebuilds: 3, Testing: 2.1.2 Description:
pg_qualstats is a PostgreSQL extension keeping statistics on predicates found
in WHERE statements and JOIN clauses.
This is useful if you want to be able to analyze what are the most-often
executed quals (predicates) on your database. The powa project makes use of
this to provide advances index suggestions.
It also allows you to identify correlated columns, by identifying which
columns are most frequently queried together.
The extension works by looking for known patterns in queries. Currently,
this includes:
- Binary OpExpr where at least one side is a column from a table. Whenever
possible, the predicate will be swaped so that CONST OP VAR expressions are
turned into VAR COMMUTED_OP CONST. AND and OR expression members are counted
as separate entries.
Ex: WHERE column1 = 2, WHERE column1 = column2, WHERE 3 = column3
- ScalarArrayOpExpr where the left side is a VAR, and the right side is an
array constant. Those will be counted one time per element in the array.
Ex: WHERE column1 IN (2, 3) will be counted as 2 occurences
for the (column1, '=') operator pair
- BooleanTest where the expression is a simple boolean column reference
Ex: WHERE column1 IS TRUE Please not that clauses like WHERE columns1,
WHERE NOT column1 won't be processed by pg_qualstats (yet)
Homepage:https://github.com/powa-team/pg_qualstats License: Apache-2.0
pg_stat_kcache
- Ebuilds: 4, Testing: 2.3.1 Description:
Gathers statistics about real reads and writes done by the filesystem layer.
It is provided in the form of an extension for PostgreSQL >= 9.4., and
requires pg_stat_statements extension to be installed. PostgreSQL 9.4 or
more is required as previous version of provided pg_stat_statements didn't
expose the queryid field.
Homepage:https://github.com/powa-team/pg_stat_kcache License: CC0-1.0
pgvector
- Ebuilds: 3, Testing: 0.8.1 Description:
Open-source vector similarity search for Postgres
Store your vectors with the rest of your data. Supports:
exact and approximate nearest neighbor search
L2 distance, inner product, and cosine distance
any language with a Postgres client
Plus ACID compliance, point-in-time recovery, JOINs, and all of the other great features of Postgres
Homepage:https://github.com/pgvector/pgvector License: Postgres
postgresql-hll
- Ebuilds: 1, Testing: 2.18 Description:
This Postgres module introduces a new data type hll which is a HyperLogLog
data structure. HyperLogLog is a fixed-size, set-like structure used for
distinct value counting with tunable precision. For example, in 1280 bytes hll
can estimate the count of tens of billions of distinct values with only a few
percent error.
In addition to the algorithm proposed in the original paper, this
implementation is augmented to improve its accuracy and memory use without
sacrificing much speed. See below for more details.
This postgresql-hll extension was originally developed by the Science team
from Aggregate Knowledge, now a part of Neustar. Please see the
acknowledgements section below for details about its contributors.
Homepage:https://github.com/citusdata/postgresql-hll License: Apache-2.0
powa
- Ebuilds: 1, Testing: 4.2.0 Description:
PoWA is a PostgreSQL Workload Analyzer that gathers performance stats and
provides real-time charts and graphs to help monitor and tune your PostgreSQL
servers.
For more information, please read:
- the PoWA main website : http://dalibo.github.io/powa/
- the Documentation : http://powa.readthedocs.io/
Homepage:http://powa-team.github.io/powa/ License: CC0-1.0
powa-collector
- Ebuilds: 1, Testing: 1.2.0 Description:
This repository contains the powa-collector tool, a simple multi-threaded
python program that performs the snapshots for all the remote servers
configured in a powa repository database (in the powa_servers table).
Homepage:https://powa.readthedocs.io/ License: MIT
powa-web
- Ebuilds: 1, Testing: 4.2.0 Description:
This project is a User Interface to the PoWA project.
For more information, please read the PoWA-web documentation:
http://powa.readthedocs.io/en/latest/powa-web/index.html
Homepage:http://powa.readthedocs.io/en/latest/powa-web/index.html License: CC0-1.0