Swapped to TimescaleDB when I migrated to Zabbix 5.0. I used a lot of your videos as a starting point because I had to migrate from Percona MySQL 8. Percona MySQL DB size was 300+GB, TSDB we're down to 11GB. Backups are also much faster using pgbackrest to an NFS share. I know that you put out a video saying that MySQL is just fine, and it served me well for over a year. But the past six months with Postgres and TSDB have been a much better experience with very little learning curve. Thanks again!
11:45 Where did this script come from, if this is a fresh installation of tdb? And most interesting: article refers to "(see database creation)" and database creation (in case of tdb) refers back to this article lol. It is not clear at all what to do after a fresh tdb installation and creation of zabbix db inside tdb.
Hello Dmitry! Please tell how to make a backup in timescaleDB without history, triggers, etc. I would like to make a quick backup that does not take up much space and time.
Please don't do that in the doc : "Then run the timescaledb.sql script ... " ... "oh and btw zabbix server must be down" - -' Otherwise great doc/guide/video as always Dmitry
Hi Dmitry, nice video, like always....question, I used this option to partition history (zabbix.org/wiki/Higher_performant_partitioning_in_PostgreSQL).....how migrate do TimeScaleDB?...Thanks and Congrats!!
► Grab your Monitoring Love Merchandise - teespring.com/stores/monitoring-it
Swapped to TimescaleDB when I migrated to Zabbix 5.0. I used a lot of your videos as a starting point because I had to migrate from Percona MySQL 8. Percona MySQL DB size was 300+GB, TSDB we're down to 11GB. Backups are also much faster using pgbackrest to an NFS share.
I know that you put out a video saying that MySQL is just fine, and it served me well for over a year. But the past six months with Postgres and TSDB have been a much better experience with very little learning curve.
Thanks again!
Hi @Chris, is there a way to chec a compresion raton on TSDB?
@@MrWysocky Not that I'm aware of. That may be available in the Zabbix template for PGSQL but I've never been concerned with it.
I think it's up to 90% compression
As usual with your videos, Dmitry; super informative, super interesting. Thank you!
My pleasure!
11:45 Where did this script come from, if this is a fresh installation of tdb?
And most interesting: article refers to "(see database creation)" and database creation (in case of tdb) refers back to this article lol. It is not clear at all what to do after a fresh tdb installation and creation of zabbix db inside tdb.
Hello Dmitry! Please tell how to make a backup in timescaleDB without history, triggers, etc. I would like to make a quick backup that does not take up much space and time.
finally, thanks :)
No problem!
Dmitry, thanks for your work. Tell me please, can Timescaledb improve performance of "select" qieries (in moments when housekeeper not active)?
Smaller database = faster queries, and compression does that :)
@@zabbixtraining Thanks, I'll try it :)
Hello, Dmitry! I have just installed timescaledb. Could you tell me how to check if it works? My configuration is Zabbix 5.4+PostgreSQL13.
\d+ history should show if there are hypertables.
@@zabbixtraining Thank you! It works really! There are the hypertables for history etc.
@@co-operator I'm glad it worked :)
Please don't do that in the doc :
"Then run the timescaledb.sql script ... "
...
"oh and btw zabbix server must be down"
- -'
Otherwise great doc/guide/video as always Dmitry
I thought it's obvious :)
Thank you very much this video very helpful, hope next video you will lease how to backup Postgresql database exclude chrunk hypertable timescale.
I will try my best
Hi Dmitry, nice video, like always....question, I used this option to partition history (zabbix.org/wiki/Higher_performant_partitioning_in_PostgreSQL).....how migrate do TimeScaleDB?...Thanks and Congrats!!
Thank you! That actually is quite bad solution for high load database, because it is based on Postgres triggers.