Catégorie : Postgresql

    source : https://www.migops.com/blog/2021/07/01/ora2pg-now-supports-oracle_fdw-to-increase-the-data-migration-speed/

WITH RECURSIVE partition_info(relid, relname, relsize, relispartition, relkind)AS (SELECT oid AS relid, relname, pg_relation_size(oid) AS relsize, relispartition, relkind      FROM pg_catalog.pg_class     WHERE relkind = ‘p’ AND relname = ‘mof_ple_part’ — Pour une […]

Convert a Standalone to a Patroni Cluster Déployer le cluster PATRONI dans un nouvel environnement

show default_tablespace ;alter system set default_tablespace=’tbs_msg_data’ ;select pg_reload_conf();show default_tablespace show temp_tablespaces ;alter system set temp_tablespaces=’temp’ ;select pg_reload_conf();show temp_tablespaces

SELECT *, pg_terminate_backend(pid)FROM pg_stat_activity WHERE pid <> pg_backend_pid()AND datname = ‘<dbname>’;# kill sessions# trouver la sessionsselect * from pg_stat_activity;select pg_terminate_backend(pid) from pg_stat_activitywhere pid = ‘PID’;

Se connecter sur le serveur cible.    pg_dumpall –roles-only -h remotehost -U remoteuser  | psql -h localhost -U localuser  pg_dump -C -h remotehost -U remoteuser dbname | psql -h localhost -U […]

Analyser un explain plan  https://explain.dalibo.com/ https://explain.tensor.ru/  

PoWA (PostgreSQL Workload Analyzer) is a performance tool for PostgreSQL 9.4 and newer allowing to collect, aggregate and purge statistics on multiple PostgreSQL instances from various Stats Extensions. Powa  les indexes bitmap n […]

postgres=> dtvsi+                                                          […]