An open source connection pooler for PostgreSQL – pgbouncer
http://www.pgbouncer.org/
PostgreSQL, Uncategorized
PostgreSQL
PostgreSQL
postgresql internals
nice write up https://www.interdb.jp/pg/ and this might help a little if you are and Oracle person moving to PostgreSQL https://wiki.postgresql.org/wiki/PostgreSQL_for_Oracle_DBAs#REDO_and_Archiving
Oracle, PostgreSQL
Simple SQL windowing functions
Here is an example function showing the maximum difference between a timestamp field in row for a given partition (the
Oracle, PostgreSQL
Oracle bulk unloading data to CSV
Well, there are a lot of new requirements to unload data from Oracle into a non-proprietary format like CSV given
PostgreSQL
Bulk loading data with AWS RDS PostgreSQL
Note that optimizing bulk loads with AWS RDS postgresql is somewhat different than using on-prem or self-hosted postgresql as you
PostgreSQL
Postgresql – How to change the default schema used by modifying search_path
What is the built-in postgresql variable “search_path”? The PostgreSQL search_path variable allows you to control what order schemas are searched
PostgreSQL
postgresql roles what they are and what you can do with them
The following link provides access to an excellent blog on the subject. https://www.crunchydata.com/blog/postgresql-defaults-and-impact-on-security-part-1 see pg_has_role select pg_has_role(<role-name>); — returns true
PostgreSQL
Don’t use these ( inexact ) postgresql data types if you need exact calculations
Here’s the definitive postgresql docs. on the all simple (not compound) numeric datatypes subject (V 14) https://www.postgresql.org/docs/current/datatype-numeric.html So why do
PostgreSQL
Using RDS postgresql and terminating other processes
Sometimes it may be necessary to terminate a postgres users process, for example if it were holding a lock an
autovacuum, PostgreSQL
Are you desparately in need of a vacuum or autovacuum is not keeping up on postgresql ?
Here is a good write-up on the subject from AWS Here is how to tell if autovacuum is currently running.