What is the advantages of postgress SQL vs Azure Cosmos db

[venkateshkumar]

I want to understand the difference between postgress SQL over Azure Cosmos DB.

[Prajwal-Microsoft]

Greeting

Hi @venkateshkumar ,

Thank you for your question!

---

Below are the differences between Postgres and Cosmos

When you select Postgres:

1. Content Vector Storage:
   The content vector is stored in a PostgreSQL database, which is used as the data source for data retrieval.
2. Chat History:
   Conversations (chat history) are stored in the PostgreSQL database.

When you select Cosmos DB:

1. Content Vector Storage:
   Azure Search is used to store the content vector, which serves as the data source for data retrieval.
2. Chat History:
   Conversations (chat history) are stored in Cosmos DB.

---

Feel free to reach out if you have any more questions!

[venkateshkumar]

Thanks for your response. Just want to know in terms of performance Azure search or postgress SQL search in case i have large corpus of data.