PostgreSQL DBA most commonly used SQL
Create relevant views according to the data dictionary to facilitate query
create schema dba;
create view dba.ro_conflicts as select datname,pg_stat_get_db_conflict_all(oid) conflict_all,pg_stat_get_db_conflict_bufferpin(oid) conflict_bufferpin,pg_stat_get_db_conflict_lock(oid) conflict_lock,pg_stat_get_db_conflict_snapshot(oid) conflict_ ...
Posted by phpnoobie on Wed, 15 Dec 2021 17:25:57 +0100
Introduction to temporary tablespaces of PostgreSQL and Greenplum
The temporary tablespace of PostgreSQL, through the parameter temp_tablespaces are configured. PostgreSQL allows users to configure multiple temporary tablespaces.
When configuring multiple temporary tablespaces, use commas to separate them.
If temp is not configured_ Tablespaces parameter. The temporary tablespace corresponds to the default ...
Posted by ajdegans on Fri, 26 Jun 2020 04:42:55 +0200