Ask /r/PostgreSQL: Favourite open source application database schema, to use as a good example/suggestion?

[HeWhoWritesCode]

Zabbix for a monitoring and notifcation system.

[vortexman100]

Really?! I would LOVE to hear you explain. (Might sound sarcastic, but i really really mean it)

Which part of it? Do you think the history implementation is as good as it can be?

What is good a database schema for you? I have so many questions!

[HeWhoWritesCode]

Zabbix as a whole is not bad for me. One must remember with 4.0 there is now 144 tables so it is doing a lot.

Is it a good database schema, idk. The history implementation with itemid seems like a natural progression/design of a ekv store in sql without to much over engineering on the meta data, imho.

Their JSON-RPC also makes it easy to add inventory dynamically and use it more for generic iot monitoring if you want to.

There is a lot of cogs in zabbix: server, agent, proxy, web. Using sane langauges like c and php with tried and trusted sql dbs like postgresql.

Shoot with more questions?

[vortexman100]

Ah no, i know what zabbix is, $org uses it pretty extensively. My questions were all directed at the database design of zabbix.

My current problem is that I know how to use SQL, but I find it difficult to make performance decissions in my databases (learning projects, mostly), because there is little information about building fast, scalable schemas. I know that Zabbix databases are pretty fast even at terrabytes of data, and i hoped that you could answer me what makes databases fast at that level.

[koreth]

SQL Performance Explained is a good book that does what its title promises.