How Postgres has adapted to AI and ML use cases using pgvector

*Find the article on our blog here:* https://pganalyze.com/blog/5mins-postgres-vectors-pgvector

In today’s episode 74 of “5mins of Postgres” we’re going to talk about vectors in Postgres. We are having a look at the claim that vectors are the new JSON in Postgres, are talk about Andrew Kane’s pgvector, and what work is needed in the Postgres core to support vectors and ML and AI work in Postgres better.

*Learn more about pganalyze:*
https://pganalyze.com
https://pganalyze.com/newsletter
https://twitter.com/pganalyze/

*Check out the pganalyze library for eBooks, webinars, and more:*
https://pganalyze.com/resources

📑 *What we have discussed in this episode of 5mins of Postgres:*

*Vectors are the new JSON in PostgreSQL – by Joanathan Katz*
https://jkatz05.com/post/postgres/vectors-json-postgresql/

*Slides for Jonathan’s lightning talk at PGCon 2023*
https://www.slideshare.net/jkatz05/vectors-are-the-new-json-in-postgresql

*Jonathan Katz on Twitter*
https://twitter.com/jkatz05

*Vectors are the new JSON in PostgreSQL – Hacker News discussion*
https://news.ycombinator.com/item?id=36481926

*pgvector – by Andrew Kane*
https://github.com/pgvector/pgvector

*Andrew Kane on Twitter*
https://twitter.com/andrewkane

*5mins of Postgres E3: Postgres performance cliffs with large JSONB values and TOAST*
https://pganalyze.com/blog/5mins-postgres-jsonb-toast

*Using Postgres JSONB Fields in Django*
https://pganalyze.com/blog/postgres-jsonb-django-python