Live data from Hacker News

TimescaleDB vs. Amazon Timestream

blog.timescale.com

111–120 of 203 posts

Re: TimescaleDB vs. Amazon Timestream

#111

I enjoy trying to guess how cloud services like Amazon Timestream are internally built. I have already bet in the past that DocumentDB was built on top of (Aurora) PostgreSQL (this I also know was possible as I founded https://torodb.com ). My bet for Timestream is that is built on top of DynamoDB. There are many potential indicators (1KB writes, throttling) and some clear ones(pricing follows the exact proportion up…

I might take toro for a spin this weekend.

Re: TimescaleDB vs. Amazon Timestream

#112
post #21

Full title includes a summary of benchmark results for the lazy: Timescaledb achieved 6000x higher inserts, 5-175x faster queries, 150x-220x cheaper Benchmarks open-source, methodology in post.

Yup, I would've kept it in the submission except the full title is 16 characters too long for the HN Title field. It felt weird to only include part of it, so I just chopped all of it off.

Re: TimescaleDB vs. Amazon Timestream

#113
post #42

What an embarrassment for AWS - getting smoked by an open source project. Should just fire the management team overseeing the timestream project and just provide managed timescaledb instances.

A decent amount of AWS product offerings get smoked by FLOSS counterparts. But being able to 1-click use something, not having to figure out how to deploy it, potentially getting commercial support for it etc. is awfully tempting even if the product is only 1/3rd as good.

Re: TimescaleDB vs. Amazon Timestream

#115
post #98

This reads like a Postgres vs DynamoDB comparison, because that’s likely what it is. The article makes a lot of points really well, and if I had 8 highly qualified people who had nothing else to do on my team working for free (or on salaries that were a rounding error in my actual and opportunity cost budget), I’d certainly get them to learn and use Timescale. But I don’t right now, so I’m going to use the option tha…

1. Timescale sells a fully managed service offering running on AWS, GCP, or Azure. So you can get started with 3-4 clicks and have a database running in 30 seconds. (We actually don't sell "software" at all - that's all free to download and run yourself.) We're fully aligned that cloud services often have lower TCO in the long run =)

https://www.timescale.com/timescale-signup

2. Beyond operations, your team probably already knows how to use much of TimescaleDB, if they know SQL and PostgreSQL. AWS Timestream, on the other hand, introduces a bunch more of strange gotcha's, as evidenced in the blog post (even from the weird SQL hoops that you need to jump through.)

Re: TimescaleDB vs. Amazon Timestream

#116
When you jumped between these AWS instance types did you tune / monitor to see what resources were becoming constrained? Or can you provide some details on network / VPC setup and changes to http connection pools in the AWS SDK? Since timescaledb is communicating over HTTP through the AWS client, I'm wondering how much you can tune to eek out performance there. I've been burned so many times across AWS services on classes of error like this that I'm just casually curious, not that anything was done "wrong".

Re: TimescaleDB vs. Amazon Timestream

#117
post #21

Full title includes a summary of benchmark results for the lazy: Timescaledb achieved 6000x higher inserts, 5-175x faster queries, 150x-220x cheaper Benchmarks open-source, methodology in post.

Yup, I would've kept it in the submission except the full title is 16 characters too long for the HN Title field. It felt weird to only include part of it, so I just chopped all of it off.

Oh yeah sorry - didn't intend as a criticism! I think the hn headline should be concise, what you have was perfect. _Maybe_ adding the word "benchmarks" could have clarified but you cover more than that in the post.

Re: TimescaleDB vs. Amazon Timestream

#118
post #81

It doesn't matter, look at kinesis. People are willing to use it over kafka (even though AWS has a hosted kafka solution), just because the percieved convenience and interconnectivity to other AWS services. If timescale starts to make serious money, then AWS can use this to mobilize their engineering and make it fast and take timescale out. Amazon's goal is literally to be the only kid on the block for everything for…

Amazon Kinesis is based on Apache Flink. One complaint might be the branding but keep in mind that the Apache Foundation has a strict policy of enforcing trademarks. The Apache Foundation itself doesn't choose winners and many equivalent projects live under the same umbrella, just like Flink and Kafka. Performance is often transient and it isn't the only criteria used when choosing a vendor. Some enterprise customers…

> My impression is that Amazon responds to customer requests to solve specific problems and they make a decent effort to continuously improve the performance and other aspects of their services.

I get that, but I would have thought it would make more sense to approach TimescaleDB for a licensing deal. That way, right from day one they get a mature product with incredible features and performance. And they'd win developer mindshare by supporting OSS.

Re: TimescaleDB vs. Amazon Timestream

#119

I enjoy trying to guess how cloud services like Amazon Timestream are internally built. I have already bet in the past that DocumentDB was built on top of (Aurora) PostgreSQL (this I also know was possible as I founded https://torodb.com ). My bet for Timestream is that is built on top of DynamoDB. There are many potential indicators (1KB writes, throttling) and some clear ones(pricing follows the exact proportion up…

> There isn’t a mechanism or support to DELETE or UPDATE existing data. The only way to remove data is to drop the entire table.

This largely accords with my experience with DynamoDB (a few years ago) as well - sql-class data management tooling was just missing.

Re: TimescaleDB vs. Amazon Timestream

#120

I enjoy trying to guess how cloud services like Amazon Timestream are internally built. I have already bet in the past that DocumentDB was built on top of (Aurora) PostgreSQL (this I also know was possible as I founded https://torodb.com ). My bet for Timestream is that is built on top of DynamoDB. There are many potential indicators (1KB writes, throttling) and some clear ones(pricing follows the exact proportion up…

> There isn’t a mechanism or support to DELETE or UPDATE existing data. The only way to remove data is to drop the entire table. This largely accords with my experience with DynamoDB (a few years ago) as well - sql-class data management tooling was just missing.

I am not entirely sure this is correct. There are definitely ways to delete or update data.
Post reply on HN