14th September 2023: PostgreSQL 16 Released!

Software Catalogue - PostgreSQL extensions

13 product(s) were found in this category.

Apache Arrow Flight SQL adapter for PostgreSQL

Description License Pricing Publisher  

Apache Arrow Flight SQL adapter for PostgreSQL is a PostgreSQL extension that adds an Apache Arrow Flight SQL endpoint to PostgreSQL.

Apache Arrow Flight SQL is a protocol to use Apache Arrow format to interact with SQL databases. You can use Apache Arrow Flight SQL instead of the PostgreSQL wire protocol to interact with PostgreSQL by Apache Arrow Flight SQL adapter for PostgreSQL.

Apache Arrow format is designed for fast typed table data exchange. If you want to get large data by SELECT or INSERT/UPDATE large data, Apache Arrow Flight SQL will be faster than the PostgreSQL wire protocol.

Open source 0 Apache Arrow View

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 information, 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_enterprise_views

Description License Pricing Publisher  

PEV enables PG to have an enterprise-level operation and maintenance monitoring system like a commercial database.

  1. Monitor OS & DB metrics
  2. Monitoring SQL statements
  3. Monitoring SQL execution plan
  4. Monitoring long term locks
  5. Monitoring long term transactions
  6. Monitor wait events
  7. Monitoring session
  8. Monitor the status of the databases
  9. Monitor the status of the tables
  10. Monitor the status of the indexes
  11. Monitor the status of the sequences
  12. Monitor the status of the functions
  13. Monitor the status of the Bgwriter process
  14. Monitor the status of the Archiver process
  15. Comes with a completely free GUI tool that allows for intuitive and convenient understanding of DB and OS status changes
Freeware Nanjing CATINFO Technologies Co., Ltd./南京开特信息科技有限公司 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_stat_monitor

Description License Pricing Publisher  

pg_stat_monitor is a Query Performance Monitoring tool for PostgreSQL. It attempts to provide a more holistic picture by providing much-needed query performance insights in a single view.

pg_stat_monitor provides improved insights that allow database users to understand query origins, execution, planning statistics and details, query information, and metadata. This significantly improves observability, enabling users to debug and tune query performance. pg_stat_monitor is developed on the basis of pg_stat_statements as its more advanced replacement.

While pg_stat_statements provides ever-increasing metrics, pg_stat_monitor aggregates the collected data, saving user efforts for doing it themselves. pg_stat_monitor stores statistics in configurable time-based units – buckets. This allows focusing on statistics generated for shorter time periods and makes query timing information such as max/min/mean time more accurate.

Open source Percona 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 must be 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

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 PostGIS PSC 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:

SELECT * FROM prefixes WHERE prefix @> '0123456789' ORDER BY length(prefix::text) LIMIT 1;

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

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.