Try our new research platform with insights from 80,000+ expert users

Faiss vs PostgreSQL comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Faiss
Ranking in Open Source Databases
14th
Ranking in Vector Databases
3rd
Average Rating
8.0
Number of Reviews
2
Ranking in other categories
No ranking in other categories
PostgreSQL
Ranking in Open Source Databases
2nd
Ranking in Vector Databases
9th
Average Rating
8.4
Number of Reviews
125
Ranking in other categories
No ranking in other categories
 

Featured Reviews

Vasu Bansal - PeerSpot reviewer
May 7, 2024
Provides quick query search and has a big database
I made some vectors for my data set. I added them and got the embeddings from Hugging Face. I made a query key-value pair for Faiss. When you want to do a query search on it, you call Faiss and send your query within it I used Faiss as a basic database. I didn't know what algorithm was being…
AdityaSharma3 - PeerSpot reviewer
Apr 11, 2024
Transaction processes are fast and good replication capability
Use cases include querying data warehouses and databases to fetch data for clients already working on PostgreSQL.  We also use Postgres for building reports It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping. The query speed is fast, and the…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"I used Faiss as a basic database."
"The product has better performance and stability compared to one of its competitors."
"It's a standard reliable database management system."
"We often use PostgreSQL for operations monitoring because we are a manufacturing company."
"The solution is scalable, it is very good."
"With the database, you can provide a multi-component at the same service with the same performance, scalability, or all those things."
"What I like is that it's quite powerful in terms of performance."
"The system can perform faster analysis by providing it with a lot of memory. Speed is crucial for analytics. Currently, the main reason we haven't adopted Elasticsearch is that we lack the necessary expertise to manage it."
"The main value is that it is open source, which means it is free. Our organization has the initiative to go to open source to cut down on cost. Oracle costs us $6 million a year right now, which is killing us, and Postgres costs nothing. So, there is a big push to go to Postgres."
"It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping."
 

Cons

"It could be more accessible for handling larger data sets."
"It would be beneficial if I could set a parameter and see different query mechanisms being run."
"I had some issues when I integrated with the Jupyter Notebook."
"The pricing could be better."
"PostgreSQL could improve by adding data warehousing tools."
"We often find the solution's datetime datatype challenging."
"It needs more integration."
"PostgreSQL doesn't have a feature for temporal SQL, which is useful for gathering versions of data. This feature should be included in PostgreSQL. This feature is available in MariaDB, SQL Server, Oracle Database, and DB2."
"They need to have a better graphical interface. There is a tool called pgAdmin 4 that they use, which is free. It is written in Java, and it is slow. They need to have a better product that is similar to Toad for Oracle, but, of course, it is hard to get something that's really great and free. Other than that, it is great."
"Sometimes, the views create problems. If you don't have the view, sometimes what happens is you need to have the drivers properly set up for PostgreSQL."
 

Pricing and Cost Advice

"Faiss is an open-source solution."
"It is an open-source tool."
"There is an annual license."
"It could be much cheaper. If you would like to build an application on Amazon today, PostgreSQL is the standard database with Redshift. If you want other databases, you can add them, but PostgreSQL is the basis of everything. It's a question of money, that's it."
"This solution can offer a cheaper choice for customers since it is open-source."
"It is open-source. If you use it on-premise, it is free. It also has enterprise or commercial versions. If you go for the cloud version, there will be a cost, but it is lower than Oracle or Microsoft."
"The licensing model is good."
"The community version of Postgre is basically free."
"It is also open-source so it is free."
"PostgreSQL is open-source, so if capable admins are available then the setup cost can be $0."
report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
815,854 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
20%
Financial Services Firm
13%
Manufacturing Company
9%
Educational Organization
8%
Computer Software Company
16%
Financial Services Firm
12%
Manufacturing Company
8%
Comms Service Provider
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about Faiss?
I used Faiss as a basic database.
What needs improvement with Faiss?
I didn't know what algorithm was being learned to fetch my query. It would be beneficial if I could set a parameter and see different query mechanisms being run. I can then compare the results to s...
How does Firebird SQL compare with PostgreSQL?
PostgreSQL was designed in a way that provides you with not only a high degree of flexibility but also offers you a cheap and easy-to-use solution. It gives you the ability to redesign and audit yo...
What do you like most about PostgreSQL?
It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping.
What is your experience regarding pricing and costs for PostgreSQL?
The tool is free of cost. For now, it's not about making money. But once we perfect it, we can offer it to customers willing to pay for support and other services. Most of my deployments are free.
 

Comparisons

 

Learn More

Video not available
Video not available
 

Overview

 

Sample Customers

1. Facebook 2. Airbnb 3. Pinterest 4. Twitter 5. Microsoft 6. Uber 7. LinkedIn 8. Netflix 9. Spotify 10. Adobe 11. eBay 12. Dropbox 13. Yelp 14. Salesforce 15. IBM 16. Intel 17. Nvidia 18. Qualcomm 19. Samsung 20. Sony 21. Tencent 22. Alibaba 23. Baidu 24. JD.com 25. Rakuten 26. Zillow 27. Booking.com 28. Expedia 29. TripAdvisor 30. Rakuten 31. Rakuten Viber 32. Rakuten Ichiba
1. Apple 2. Cisco 3. Fujitsu 4. Instagram 5. Netflix 6. Red Hat 7. Sony 8. Uber 9. Cisco Systems 10. Skype 11. LinkedIn 12. Etsy 13. Yelp 14. Reddit 15. Dropbox 16. Slack 17. Twitch 18. WhatsApp 19. Snapchat 20. Shazam 21. SoundCloud 22. The New York Times 23. Cisco WebEx 24. Atlassian 25. Cisco Meraki 26. Heroku 27. GitLab 28. Zalando 29. OpenTable 30. Trello 31. Square Enix 32. Bloomberg
Find out what your peers are saying about Faiss vs. PostgreSQL and other solutions. Updated: October 2024.
815,854 professionals have used our research since 2012.