#storage TOAST strategy: PLAIN, EXTENDED, EXTERNAL, MAIN
https://www.postgresql.org/docs/current/storage-toast.html#STORAGE-TOAST-ONDISK
https://www.postgresql.org/docs/current/storage-toast.html#STORAGE-TOAST-ONDISK
PostgreSQL Documentation
66.2. TOAST
66.2. TOAST # 66.2.1. Out-of-Line, On-Disk TOAST Storage 66.2.2. Out-of-Line, In-Memory TOAST Storage This section provides an overview of TOAST (The …
#query #null https://www.cybertec-postgresql.com/en/a-postgresql-story-about-null-is-null-null-and-not-null/
CYBERTEC
A PostgreSQL story about "NULL IS NULL = NULL AND NOT NULL"
Why the word "unknown" is better to describe a NULL value than "empty". Basic rules for handling NULL values in PostgreSQL.
Detecting which #index types are available for my column type
SELECT DISTINCT
a.amname
FROM
pg_type t
JOIN pg_opclass o ON o.opcintype = t.oid
JOIN pg_am a ON a.oid = o.opcmethod
WHERE
t.typname = 'int4';
amname
--------
btree
hash
brin
(3 rows)
#query https://info.crunchydata.com/blog/tentative-smarter-query-optimization-in-postgres-starts-with-pg_stat_statements
Crunchydata
Query Optimization in Postgres with pg_stat_statements
"I want to work on optimizing all my queries all day long because it will definitely be worth the time and effort," is a statement that has hopefully never been said. So when it comes to query optimizing, how should you pick your battles?