~postgresweekly | Bookmarks (2)

11 Lessons to Learn When Using NULLs — NULL represents a missing, unknown or ‘non’-value in SQL and it has some interesting properties and behaviors to be aware of.

▶  Jonathan Katz on pgvector — Postgres core team member Jonathan Katz went on the Postgres.fm podcast to talk about the increasingly popular pgvector extension, its use cases, indexing approaches, and how TOAST gets involved, along with host Michael Christofides.