We performed a comparison between PostgreSQL and SingleStore based on real PeerSpot user reviews.
Find out in this report how the two Vector Databases solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is easy to use."
"It's a useful solution, that can be widely used."
"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."
"PostgreSQL is very powerful, easy to manage, and has many features."
"It's a transactional database, so we use Postgres for most of our reporting. That's where it's helping."
"We are able to create many different types of jobs and items with this solution making it one of the most valuable features."
"Initial setup is simple."
"It has completely met our needs. It works, and it is robust. We haven't had any problems with what PostgreSQL does for us and the way it does it. That's why we've been using it for so long. We understand it, and it does the job."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The paramount advantage is the exceptional speed."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"They need to improve the user experience of the management."
"There are several features I would like to improve that aren't working as expected. It's likely that the latest version is doing something that was missed in the previous versions. For example, the output parameters — the stored procedures — is something new in PostgreSQL that Firebird has already had for a long time."
"It could be more secure."
"There are some products out there that have a slightly different method of implementation for the SQL language. Some of those are slightly better in some areas, and PostgreSQL is slightly better in some areas. I would probably like to match all of those products together. It is just down to the functionality. For example, Oracle has a number of options within SQL that are outside of what you would class as the SQL standard. PostgreSQL misses some of those, but PostgreSQL does other things that are better than what Oracle does. I would like to merge those two products so that there is a certain amount of functionality in a single product."
"It could be improved by using parallelization. You want basically, distributed computing."
"PostgreSQL’s performance could be improved."
"The interface climate could be better."
"The user interface for the clients could be easier to use as they are small businesses. From a technical support perspective, the documentation could be improved."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"We don't get good discounts in Pakistan."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
PostgreSQL is ranked 7th in Vector Databases with 123 reviews while SingleStore is ranked 10th in Vector Databases with 7 reviews. PostgreSQL is rated 8.4, while SingleStore is rated 8.8. The top reviewer of PostgreSQL writes " Real-time data capture optimizes database performance but Views create problems". On the other hand, the top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". PostgreSQL is most compared with Firebird SQL, EDB Postgres Advanced Server, MySQL, MariaDB and SQLite, whereas SingleStore is most compared with SQL Server, MySQL, Teradata, CockroachDB and Oracle Database. See our PostgreSQL vs. SingleStore report.
See our list of best Vector Databases vendors.
We monitor all Vector Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.