Peak Performance – pgvector vs. PostgreSQL ARRAY for mass spectrometry databases
The native way to handle vectors in PostgreSQL are ARRAYs. They are first class citizens of PostgreSQL and come with lots of functionality out of the box. But now there is pgvector...