分类: ADMIN
51 个扩展
-
pg_repack
Reorganize tables in PostgreSQL databases with minimal locks
-
pg_rewrite
Tool allows read write to the table during the rewriting
-
pg_query_rewrite
Rewrite SQL statements with a PostgreSQL ProcessUtility hook
-
pg_squeeze
A tool to remove unused space from a relation.
-
pg_dirtyread
Read dead but unvacuumed rows from table
-
pgfincore
examine and manage the os buffer cache
-
pg_cooldown
remove buffered pages for specific relations
-
ddlx
DDL eXtractor functions
-
pglinter
PostgreSQL Linting and Analysis Extension
-
prioritize
get and set the priority of PostgreSQL backends
-
pg_checksums
Activate/deactivate/verify checksums in offline Postgres clusters
-
pg_integrity_checksums
Physical and logical checksums for PostgreSQL pages, rows, tables, indexes and databases.
-
pg_readonly
cluster database read only
-
pgdd
Introspect pg data dictionary via standard SQL
-
pg_permissions
view object permissions and compare them with the desired state
-
pgautofailover
pg_auto_failover
-
pg_catcheck
Diagnosing system catalog corruption
-
pre_prepare
Pre Prepare your Statement server side
-
pg_upless
Detect Useless UPDATE
-
pgcozy
Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
-
pg_orphaned
Deal with orphaned files
-
pg_crash
Send random signals to random processes
-
macavity
Deterministic session-local fault injection for PostgreSQL test clusters
-
pg_cheat_funcs
Provides cheat (but useful) functions
-
fio
PostgreSQL File I/O Functions
-
qos
QoS resource governor extension for PostgreSQL sessions and queries
-
pg_pathcheck
Validate planner Path trees for freed or corrupt memory
-
pgdisablelogerror
Disable selected SQLSTATE error codes from PostgreSQL server logging.
-
online_advisor
Suggest missing indexes and extended statistics online
-
pg_column_tetris
Enforce optimal column alignment to minimize row padding
-
cat_tools
Tools for interfacing with the PostgreSQL catalog
-
pg_living_assertions
Executable SQL checks with verdict dates and assertion history
-
pg_savior
Postgres extension to save OOPS mistakes
-
pg_circuit
Runtime observation, warnings and blocking for dangerous SQL statements
-
safeupdate
Require criteria for UPDATE and DELETE
-
pg_strict
Prevent dangerous UPDATE and DELETE without WHERE clause
-
pg_drop_events
logs transaction ids of drop table, drop column, drop materialized view statements
-
table_log
record table modification logs and PITR for table/row
-
pgelog
Extended logging via pseudo-autonomous transactions
-
pgagent
A PostgreSQL job scheduler
-
pg_prewarm
prewarm relation data
-
pgpool_adm
Administrative functions for pgPool
-
pgpool_recovery
recovery functions for pgpool-II for V4.3
-
pgpool_regclass
replacement for regclass
-
lo
Large Object maintenance
-
basic_archive
an example of an archive module
-
basebackup_to_shell
adds a custom basebackup target called shell
-
old_snapshot
utilities in support of old_snapshot_threshold
-
adminpack
administrative functions for PostgreSQL
-
amcheck
functions for verifying relation integrity
-
pg_surgery
extension to perform surgery on a damaged relation