#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?
#perf #concurrency https://buttondown.email/nelhage/archive/notes-on-some-postgresql-implementation-details/
buttondown.email
Notes on some PostgreSQL implementation details
Ranger update Seriously friends he has gotten so large. He knows his name and comes when called, like, 80% of the time. He turned four months old today, just...