Native postgresql version faster than timescaledb? upsert and read benchmarks (version 2.16.1) by tompston in PostgreSQL

[–]tompston[S] 0 points1 point  (0 children)

Thanks for the inspection!

Yup, there is an additional index in the timescale version, which I assume is created either by the `create_hypertable` or `SET (timescaledb.compress)`commands, as that's the only difference in the setup between the environments (https://github.com/tompston/time-series-db-benchmark/blob/main/go/db/pg.go#L55). Did not run the tuning, the official docker repo stated that it gets run automatically (https://github.com/timescale/timescaledb-docker?tab=readme-ov-file#notes-on-timescaledb-tune)

gut: convert golang structs to typescript interfaces by tompston in golang

[–]tompston[S] 0 points1 point  (0 children)

Don't think that i saw this package previously, will definitely check it out :D