pg_squeeze
A tool to remove unused space from a relation.
Module:
Categories:
Overview
PGDG 1st Party Extension: pg_squeeze
: A tool to remove unused space from a relation.
Information
- Extension ID: 5020
- Extension Name:
pg_squeeze
- Package Name:
pg_squeeze
- Category:
ADMIN
- License: BSD 2
- Website: https://github.com/cybertec-postgresql/pg_squeeze
- Language: C
- Extra Tags: N/A
- Comment: N/A
Metadata
- Latest Version: 1.8
- Postgres Support:
17
,16
,15
,14
,13
- Need Load: Explicit Loading Required
- Need DDL: Need
CREATE EXTENSION
DDL - Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas:
squeeze
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pg_squeeze_$v*
- RPM Ver :
1.8
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-squeeze
- DEB Ver :
1.8
- DEB Deps: N/A
Packages
Installation
Install pg_squeeze
via the pig
CLI tool:
pig ext install pg_squeeze
Install pg_squeeze
via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_squeeze"]}' # -l <cls>
Install pg_squeeze
RPM from YUM repo directly:
dnf install pg_squeeze_17*;
dnf install pg_squeeze_16*;
dnf install pg_squeeze_15*;
dnf install pg_squeeze_14*;
dnf install pg_squeeze_13*;
Install pg_squeeze
DEB from APT repo directly:
apt install postgresql-17-squeeze;
apt install postgresql-16-squeeze;
apt install postgresql-15-squeeze;
apt install postgresql-14-squeeze;
apt install postgresql-13-squeeze;
Extension pg_squeeze
has to be added to shared_preload_libraries
shared_preload_libraries = 'pg_squeeze'; # add to pg cluster config
Enable pg_squeeze
extension on PostgreSQL cluster:
CREATE EXTENSION pg_squeeze;
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.