PostgreSQL External Projects

pg_hint_plan: The hint table

Summary: The pg_hint_plan extension provides a hint table, through which you can change the execution plan of a query in a convenient way.

Continue reading

pg_hint_plan: Introduction

Summary: The pg_hint_plan extension gives PostgreSQL ability to manually force some decisions in execution plans.

Continue reading

pg_stat_kcache: Gather I/O and CPU statistics of queries

Summary: The pg_stat_kcache extension gathers statistics about physical disk access and CPU consumption done by backends.

Continue reading

pg_qualstats: PostgreSQL index advisor

Summary: The pg_qualstats extension gathers statistics about predicates, helping find what indices are missing.

Continue reading

hypopg: Hypothetical Indexes

Summary: A hypothetical, or virtual, index is an index that does not really exist, and therefore does not cost CPU, disk or any resource to create. They are useful to find out whether specific indexes can increase the performance for problematic queries, since you can discover if PostgreSQL will use these indexes or not without having to spend resources to create them.

Continue reading

pgagroal: Getting started

Summary: The pgagroal is a high-performance connection pool for PostgreSQL.

Continue reading

pgBadger: a fast PostgreSQL log analysis report

Summary: pgBadger is a tool, which can be used to generate log analysis report in PostgreSQL.

Continue reading

check_postgres: PostgreSQL monitoring script

Summary: check_postgres.pl is a PostgreSQL monitoring script for Nagios, MRTG, Cacti, and others.

Continue reading

mysql_fdw: Foreign Data Wrapper for MySQL

Summary: mysql_fdw is a PostgreSQL extension, which implements a Foreign Data Wrapper (FDW) for MySQL.

Continue reading

db_migrator: Migrate other databases to PostgreSQL

Summary: db_migrator is a PostgreSQL extension that provides functions for migrating databases from other data sources to PostgreSQL.

Continue reading