Software Catalogue - PostgreSQL extensions

12 product(s) were found in this category.

HypoPG

Description License Pricing Publisher  

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.

For more thorough informations, please consult the oficial documentation.

Open source Free Julien Rouhaud View

OpenFTS

Description License Pricing Publisher  

OpenFTS (Open Source Full Text Search engine) is an advanced PostgreSQL-based search engine that provides online indexing of data and relevance ranking for database searching. Close integration with database allows use of metadata to restrict search results.

Open source OpenFTS Project View

pg_qualstats

Description License Pricing Publisher  

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.

Open source Free PoWA View

pg_stat_kcache

Description License Pricing Publisher  

Gathers statistics about real reads and writes done by the filesystem layer and a lot of other kernel metrics.

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.

Open source Free PoWA View

pg_track_settings

Description License Pricing Publisher  

pg_track_settings is a small extension that helps you keep track of postgresql settings configuration.

It provides a function (pg_track_settings_snapshot()), that me must called regularly. At each call, it will store the settings that have been changed since last call. It will also track the postgresql start time if it's different from the last one.

This extension tracks both overall settings (the pg_settings view) and overloaded settings (the pg_db_role_setting table).

Open source Free Julien Rouhaud View

PipelineDB v1.0.0

Description License Pricing Publisher  

PipelineDB is a PostgreSQL extension that enables continuous aggregation on streams of time-series data. It is licensed under the Apache 2.0 open-source license.

Open source Free PipelineDB View

PL/Proxy

Description License Pricing Publisher  

PL/Proxy is database partitioning system implemented as PL language.

Open source Skype View

PostGIS

Description License Pricing Publisher  

PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS follows the OpenGIS "Simple Features Specification for SQL" and has been certified as compliant with the "Types and Functions" profile.

Open source Refractions Research View

PostPic

Description License Pricing Publisher  

PostPic is an extension for the open source dbms PostgreSQL that enables image processing inside the database, like PostGIS does for spatial data. It adds the new 'image' type to the SQL, and several functions to process images and to extract their attributes.

Open source Domenico Rotiroti View

prefix

Description License Pricing Publisher  

The prefix project implements text prefix matches operator (prefix @> text) and provide a GiST opclass for indexing support of prefix searches.

Typical query like the following is now able to benefit from index lookups, as soon as the prefix column is of type prefix_range: [HTML_REMOVED] SELECT * FROM prefixes WHERE prefix @> '0123456789' ORDER BY length(prefix::text) LIMIT 1; [HTML_REMOVED]

Open source Freely available, BSD licence Dimitri Fontaine View

Texcaller

Description License Pricing Publisher  

Texcaller is a convenient interface to the TeX command line tools that handles all kinds of errors without much fuzz. It is written in plain C, is fairly portable, and has no external dependencies besides TeX.

These PostgreSQL functions are simple wrappers around the Texcaller C interface library functions, bringing TeX typesetting into the world of relational databases.

Invalid TeX documents are handled gracefully by simply returning NULL rather than aborting with an error. On failure as well as on success, additional processing information is provided via NOTICEs.

Open source Volker Grabsch View

TimeTravel

Description License Pricing Publisher  

TimeTravel is an added functionality to PostgreSQL which we developed by drawing inspiration from a similar Oracle functionality: FlashBack. Since human errors are among the first causes of data loss, it would be a good idea to maintain historical details of all transactions, for a limited time, to be able to rollback a committed transactions when it will be needed.

Open source D&T srl View

Note: The PostgreSQL Global Development Group do not endorse or recommend any products listed, and cannot vouch for the quality or reliability of any of them.