Tuning and Configuring PG
https://pgconfigurator.cybertec-postgresql.com/

TOPIC: Using DB-FIDDLE.com
https://www.db-fiddle.com/f/7hPsTQ9pmowpgz3tnGFSc7/2

This specific fiddle actually has COMMENTS explaining how to use it!
And how the link changes.
I don't know how long that link sticks around!

Understanding Concurrency in PostgreSQL
Well worth reading:
https://www.postgresql.org/docs/current/mvcc.html

Things to AVOID Doing with PostgreSQL:
https://wiki.postgresql.org/wiki/Don%27t_Do_This

Training Videos [This will be broken down into a series, with some descriptions of level, quality]

This is Microsoft Azure Centric:
https://www.youtube.com/@azurelibacademy4673

PGAnalyze, 5 Minutes of PostgreSQL
https://www.youtube.com/@pganalyze6516

UDEMY has a PG Class that starts with installing PG... And covers the basics for the beginner.

https://www.udemy.com/course/advanced-sql-bootcamp/?utm_source=adwords&utm_medium=udemyads&utm_campaign=SQL_Search_la.EN_cc.US_PP_Control&utm_content=deal4584&utm_term=_._ag_141124575332_._ad_594266299839_._kw__._de_c_._dm__._pl__._ti_dsa-1652644802385_._li_9012017_._pd__._&matchtype=&gclid=CjwKCAiA2fmdBhBpEiwA4CcHzYtX_VgRqEEnkgvKD0PATxhVJX5aehUrzA9Dp8ssYCanCTHoKs8RihoCMmgQAvD_BwE

Training:
Some here: https://proopensource.it/blog/learning-postgresql
some here: https://www.udemy.com/course/advanced-sql-bootcamp/?utm_source=adwords&utm_medium=udemyads&utm_campaign=SQL_Search_la.EN_cc.US_PP_Control&utm_content=deal4584&utm_term=_._ag_141124575332_._ad_594266299839_._kw__._de_c_._dm__._pl__._ti_dsa-1652644802385_._li_9012017_._pd__._&matchtype=&gclid=CjwKCAiA2fmdBhBpEiwA4CcHzYtX_VgRqEEnkgvKD0PATxhVJX5aehUrzA9Dp8ssYCanCTHoKs8RihoCMmgQAvD_BwE

Window Functions (RANK, DENS RANK, LEAD/LAG)
https://www.youtube.com/watch?v=Ww71knvhQ-s

How to get pastebin on your phone, and then use the QR Code feature of the browser, to get your text into a Telegram (or other chat)
https://pastebin.com/

fond this repo some time ago, has some nice tools:
https://github.com/Azmodey/pg_dba_scripts

For those who ask "Why Not Just use NUMERIC" versus BIGINT for keys.
I have a large table (5 billion+ rows). I freshly loaded this. And I created indexes.
One was (bigint,bigint) and another was (numeric, bigint).

3x longer to create the (numeric,bigint). And it was all basically I/O.
I started them both at the same time, to take advantage of reading the same file.
The first one was done in 8hrs.
The second one, was the only thing running on the machine. And it took an additional 16hrs to complete.

The size of your columns matter.

Do you have write queries that take forever to run?
This is an approach to Batch Based processing, with independent transactions.
And the ability to keep track and display a Progress Bar.

It leverages PSQL \watch to work it's magic...
Well worth reading.

https://postgres.ai/blog/20220114-progress-bar-for-postgres-queries-lets-dive-deeper

Deleting ONLY the duplicates (leaving 1 row behind), with full control over batch sizes.

I've seen this question come up NUMEROUS times in various forums.
I've based this implementation on the work of others. (@Nikoay_S)
This is a GOOD LEARNING PIECE.

This seems straight forward enough.

Effectively, you can limit the number of rows you have coming back.
I have it set to 100 here.

The trick is HAVING count(1) > 1. This means each time you run, you will get at new set to work with.
Notice the way this runs, using the \WATCH command as a loop. (but it's an infinite loop. Version 16 of psql has iteration control!) [Also, this means it doesn't work in GUI tools]

Each iteration is it's own transaction. When you are done, the table is bloated (it should be vacuumed).
[I guess you could also use ROW_NUMBER OVER (PARTITION) rn ... WHERE rn > 1)]

— SETUP
drop table if exists big;
create temp table big ( other_val int );
insert into big select gs % 1000 + 1 from generate_series(1, 5000000) as gs;
create index on big (other_val);
vacuum analyze big;


DELETE from big
USING (select count(1) as cnt, other_val, min(ctid) as min_ctid from big group by other_val having count(1)>1 order by other_val desc limit 100) as dupes
where big.Other_val = dupes.other_val AND big.ctid > dupes.min_ctid;
\watch 0.5

TRAINING...
EnterpriseDB Offers Free Training here:

https://www.enterprisedb.com/training

Things to consider when Converting from Oracle to Postgresql
This is going to be a CHAT conversation of knowledge to help others.

PITR For Beginners!

https://www.highgo.ca/2023/05/09/various-restoration-techniques-using-postgresql-point-in-time-recovery/

Adding some More Ideas...

https://www.youtube.com/watch?v=FsUcaPJlYjY&list=PLS-kiDL9KrIh-E5eadtnp-8l55H7e2LN0
https://www.youtube.com/watch?v=wByi8mk8JWg&list=PLxtrcgLvnR2Zx2h4VYqCkwIb_vQ6WKp3L
https://www.youtube.com/watch?v=nyQ_MVmKcgE&list=PLk1kxccoEnNHlAR2ggnzIkOc7jxqI-_w2
https://www.youtube.com/watch?v=-pUTNi2MStQ&list=PLVISlbl_zTWI00-tis9dkCguVUxFUPOcK
https://www.youtube.com/watch?v=mdMfOYn-H4I&list=PLH8y1BNPAKjI8DOvNV-qKmhokO_oeICnO