Postgres vector database

Pleasantly surprised to find out that there is now an extension that enables Postgres to act a vector db. Does anyone have experience with this extension outside the lab here? If so, how does it compare to Weaviate and/or Pinecone? Thank you.