Wednesday, February 24, 2021

PostgreSQL: How to set number of parallel workers in a session

›
SET max_parallel_workers_per_gather=num; Default is num=2, which will give you 3 processes in total (1 master + 2 workers). If set t...
Friday, February 19, 2021

How to find the number of huge pages to set on a PostgreSQL server

›
Thanks to Ibrar Ahmed for posting the article " Tune Linux Kernel Parameters For PostgreSQL Optimization " Log on to the serv...
Tuesday, February 9, 2021

How to loop through tables in a schema in PostgreSQL and show estimated number of rows

›
To loop through all tables in a schema called "myschema", in a database called "proddb01" you can put the following in...

How to turn off output generated by psql

›
I guess this could be viewed as the equivalent to oracles "set" statements in sqlplus, for example "set heading off verify...

How to extract estimated number of rows from a PostgreSQL table

›
prod=# SELECT reltuples::BIGINT AS estimate FROM pg_class WHERE relname='yourtable'; estimate ---------- 42223028 (1 row) To i...
Friday, February 5, 2021

Find duplicate file names

›
You can find duplicate file names, on different file systems, by using this query: set lines 200 col "file_name" format a30 col...
Friday, January 29, 2021

How to manually register missing logsequences on a standby database

›
I have previously documented how to identify gaps in your standby database's log sequence. See these posts: How to check if your phy...