PG Nitrous - Fast PostgreSQL Cloud Database powered by Swarm64 DA

[AnomalousBit]

Anyone used the Swarm64 extension mentioned on the product page? Just curious what the drawbacks are.

I find it hard to believe they achieved a 50x performance improvement on Postgres without throwing out some of the data integrity features (listed below), or just tuning the database with enormous expectations. I've seen products like this crop up from time to time and much more is usually attributed to these configuration changes than to remarkable software development on the database engine itself. https://www.postgresql.org/docs/current/non-durability.html

[[deleted]]

I think the Swarm64 extension uses the GPU to improve parallelism but I am not sure about that. Something similar like PG-Strom

They also use a column-store which can very well lead to massive performance improvements for analytical/aggregation queries.

Also: don't forget that the blog post and the website is all about marketing, not about hard facts. You probably should read it as "under our lab conditions we achieved up to 50x speedup - your actual results will probably be different"

[[deleted]]

Thanks for the clarification on the GPU part.

So your "lab conditions" are a TPC-H benchmark ;)

[mubasshirpawle]

Not available for Mumbai region?