4 ms·
I've been considering TimescaleDB for some use cases. Specifically to keep a transactional log of messages sent out. Has anyone independently benchmarked Times
by timescale11 5y ago
I've been considering TimescaleDB for some use cases. Specifically to keep a transactional log of messages sent out.
Has anyone independently benchmarked TimescaleDB vs Postgres w/ B-Tree vs Postgres w/ BRIN? Given that most timescale data would benefit greatly from BRIN, I'm surprised their various blog posts never cover it.
I have discovered one person who tried to replicate some of the benchmarks around Postgres vs TimescaleDB (back in 2019), but they came up with data that contradicts the latest blog post around TimescaleDB vs Postgres performance, which makes me reconsider whether I really need what TimescaleDB provides. Maybe there have been large changes since then?
http://blog.coelho.net/database/2019/09/13/postgresql-vs-timescaledb-data-loading-performance.html http://blog.coelho.net/database/2019/09/13/postgresql-vs-tim...
https://blog.timescale.com/blog/timescaledb-vs-6a696248104e/ https://blog.timescale.com/blog/timescaledb-vs-6a696248104e/
- fny 5y agoIf you have a real use case, just build it with vanilla pg. Once you start feeling pain with pg, migrate to timescale and see what happens. You may never end up needing the performance boost they advertise.
- nullwarp 5y agoI'll just add it's extremely easy to migrate, pg_dump and then just load it back up.